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 How to conditionally determine Workbook save compatibility in VBA?

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
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
2007 Compatibility Pack -- Save As context menu AndyE46 Excel Discussion (Misc queries) 1 December 11th 09 05:28 PM
Excel 2007 save compatibility issue Sarang[_2_] Excel Programming 1 May 14th 07 10:24 AM
Getting data for a workbook from another workbook conditionally confused Excel Programming 0 April 19th 06 06:59 PM
Determine whether a wrkbook have been changed since the last save Henk Frigge[_2_] Excel Programming 2 January 11th 06 10:21 PM
Save Event - Determine if called by code or user David Sedberry Excel Programming 0 October 2nd 03 04:56 PM


All times are GMT +1. The time now is 02:28 AM.

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"