LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default XL07 - How to conditionally determine Workbook file format compatibility in VBA?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
[XL07] Conditionally format fill color for entire row Trevor Stone Excel Worksheet Functions 11 July 31st 08 10:26 PM
conditionally format anumber format Montana Excel Worksheet Functions 5 January 15th 08 05:25 PM
How to conditionally determine Workbook save compatibility in VBA? keeena Excel Programming 1 July 19th 07 03:01 PM
VBA Access lost after 2007 file format compatibility pack installe roanokesys Excel Discussion (Misc queries) 2 May 24th 07 11:49 AM
Conditionally format Terri Excel Programming 1 November 15th 04 08:06 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"