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. 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 | |||
2007 Compatibility Pack -- Save As context menu | Excel Discussion (Misc queries) | |||
Excel 2007 save compatibility issue | Excel Programming | |||
Getting data for a workbook from another workbook conditionally | Excel Programming | |||
Determine whether a wrkbook have been changed since the last save | Excel Programming | |||
Save Event - Determine if called by code or user | Excel Programming |