Macro not to check compatibility when saving this workbook

F

fruitchunk

I recorded a macro in excel, it works fine but stops by "Compatibility
Checker".
Can I have it in the macro "not to check compatibility when saving this
workbook", I don't want to disable the Compatibility Checker completely in
excel only in this macro.
Please help.
 
R

Ron de Bruin

Use this in 2007 and up and like Patrick told you stay in your first thread

ThisWorkbook.CheckCompatibility = False
ThisWorkbook.Save
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro "not to check compatibility when saving this workbook" 4
Macro not to check compatibility when saving this workbook 2
2007: CheckCompatibility not honored 2
How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent? 1
How to conditionally determine Workbook save compatibility in VBA? 1
XL07 - How to conditionally determine Workbook file format compatibility in VBA? 5
checkcompatibility not working in Windows 7 4
Avoiding Compile Error for Unsupported Methods 2

Top