PDA

View Full Version : Solved: bypassing the Compatibility Check in Excel 2007



gcomyn
09-24-2010, 11:31 AM
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
:sleuth:

gcomyn
09-24-2010, 11:56 AM
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
:sleuth: