C
Charlie W
I have an Excel macro that I use on several PCs. The macro uses the SaveAs
method to save a copy of the sheet as a separate workbook. The macro code
contains the code:
activeworkbook.checkcompatibility = false
activeworkbook.saveas ...
On PCs running XP and both Office 2003 and Office 2007 it saves the copy
without incident. On a PC running Office 2007 and Windows-7, it always
displays the Compatibility Checker warning. Also, after the SaveAs on the
Win-7 platform has executed, I notice that CheckCompatibility is set to true
again.
Any ideas how to prevent Win-7 from resetting the CheckCompatibility flag?
Thanks
method to save a copy of the sheet as a separate workbook. The macro code
contains the code:
activeworkbook.checkcompatibility = false
activeworkbook.saveas ...
On PCs running XP and both Office 2003 and Office 2007 it saves the copy
without incident. On a PC running Office 2007 and Windows-7, it always
displays the Compatibility Checker warning. Also, after the SaveAs on the
Win-7 platform has executed, I notice that CheckCompatibility is set to true
again.
Any ideas how to prevent Win-7 from resetting the CheckCompatibility flag?
Thanks