Compatibility Checker causing headaches

[Brian]

Can anyone tell me (PLEASE!) if and how it is possible to get Excel to stop
popping up the compatibility checker dialog box? I am writing a macro that
must run through a loop and save multiple files in 2003-07 format. But,
every time it tries to save a file, the dialog box pops up...kind of throwing
a kink in the whole "automation" process.

 

[Carim]

Hi,

The instruction
Application.DisplayAlerts = False
should do the job ...

HTH
Carim

 

[Brian]

Thank you so much!
This sounds like it will do the trick for me
Brian.