Macro "not to check compatibility when saving this workbook"

[fruitchunk]

I recorded a macro in excel. it works fine but stops before saving the file
and i get the "Compatibility Checker".
Is it possible to have it in the macro "not to check compatibility when
saving this workbook" ? I don't want to disable "Compatibility Checker" from
excel just for this macro.
Please help.

 

[Patrick Molloy]

maybe try adding

Application.DisplayAlerts = False

just prior to the code that saves the file

 

[Michael Arch]

Application.DisplayAlerts = False
SEt at the beginning of your code to stop it from asking during execution,
but if you don't want to completely disable it, you must set it back to true
at the end of your macro.
Application.DisplayAlerts = True

--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.

 

[Ron de Bruin]

Use this in 2007 and up

ThisWorkbook.CheckCompatibility = False
ThisWorkbook.Save

 

[fruitchunk]

Thanks for all your help.

P.S. Sorry about the duplicate posts, my mistake.