-
Solved: bypassing the Compatibility Check in Excel 2007
I process a lot of excel spreadsheets using Excel 2007 that were created in older (2000-2003) versions of excel, and sometimes when I edit a file (via vba) I get the Compatibility Checker.
I am trying to find out if there is a way to bypass this when closing the file with the VBA code.
I've searched to see if this question has been asked before, but haven't found any instances yet.
GComyn
-
Ok... after further searching, I found the Workbook.CheckCompatibility boolean property.
I've incorporated it into my code, and it seems to work so far. (I've only had 1 workbook to process since I found it).
So, I'm marking this a solved.
GComyn
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules