Messages in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.

.
Click to expand...
 
Back
Top