Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to know how to invoke compatibility checker via VBA, or
similar functionality, in Excel 2007. I searched around the Object Browser and Microsoft Team Blog for an answer, but didn't find anything at this point (http://blogs.msdn.com/ excel/default.aspx). I would like to do is save all Workbooks in my scripts as 95-2003 format (.SaveAs FileFormat = xlExcel8) whenever possible. So I need a way to programmatically determine if the Workbook can be properly saved in this format. I'd basically like to invoke the Compatibility Checker via VBA. Or, alternatively, are there ways to conditionally check the compatibility of the Workbook prior to saving? This is all assuming a newly created workbook which has not been saved yet. I would rather not have to create my own checks for every possible 2K7 difference (e.g. data in rows 64k, etc...) :) TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
[XL07] Conditionally format fill color for entire row | Excel Worksheet Functions | |||
conditionally format anumber format | Excel Worksheet Functions | |||
How to conditionally determine Workbook save compatibility in VBA? | Excel Programming | |||
VBA Access lost after 2007 file format compatibility pack installe | Excel Discussion (Misc queries) | |||
Conditionally format | Excel Programming |