No message box displayed
 

Hello. I am running a macro that save my files in Excel 4 format after
doing what have to be done ( I have more then 50 files). However, Excel
is always warning me that the file that i want to save is in Excel 4
format and I always need to press the ok button.

I am sure that there is a way for me to tell Excel that I do not want
any message displayed (that will necessitate my intervention) when the
macro is running. Can you please help me out? Thanks for your help!

No message box displayed
 

Untested:

application.displayalerts = false
'your code to save as xl4
application.displayalerts = true



Marc wrote:

Hello. I am running a macro that save my files in Excel 4 format after
doing what have to be done ( I have more then 50 files). However, Excel
is always warning me that the file that i want to save is in Excel 4
format and I always need to press the ok button.

I am sure that there is a way for me to tell Excel that I do not want
any message displayed (that will necessitate my intervention) when the
macro is running. Can you please help me out? Thanks for your help!

--

Dave Peterson