Messages in Excel

[Guest]

I am runing a Excel Macro from Access. When I go to save
the file, it asks me if I would like to overwrite an
already existing file. I would like the macro to
overwrite without any intervension.

When I run the macro, I see the actions in fast-forward.
I do not want to confuse the user. Is there a way I can
display an hour glass and have the actions go on in the
background and inform the user once the actions are over?

Thanks

 

[Frank Stone]

in the xl macro insert the following

Application.DisplayAlerts = False
save file
Application.DisplayAlerts = True
this should turn off the overwrite prompt while you save
the file. you turn alerts on again after the save

Application.ScreenUpdating = False
run code
Application.ScreenUpdating = True
I have not tried this sniplet but i am told it works.

 

[Guest]

thanks Frank

-----Original Message-----
in the xl macro insert the following

Application.DisplayAlerts = False
save file
Application.DisplayAlerts = True
this should turn off the overwrite prompt while you save
the file. you turn alerts on again after the save

Application.ScreenUpdating = False
run code
Application.ScreenUpdating = True
I have not tried this sniplet but i am told it works.

.