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: 2
Default Determining whether a workbook is a 2003 or 2007 workbook

Hi,

Since users can resave a workbook in .xlsx format, is there a recommended
way of determining whether a workbook supports 2007's increased rows and
columns? I display a warning when the user tries to display something
greater than the max columns or rows and checking the Application.Version
only works when the user opens
a. Excel 2003 application and 2003 workbook
b. Excel 2003 application and 2007 workbook
c. Excel 2007 application and 2003 workbook

I would like to handle the case where the workbook imposes the smaller limit.
d. Excel 2007 application and 2003 workbook

Is there a better method than checking the file extension?

Thanks!
 
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 workbook for 2003 client cyberfreak Excel Discussion (Misc queries) 1 February 7th 09 12:55 AM
excell workbook 2007 to 2003 cyberfreak Excel Discussion (Misc queries) 0 February 6th 09 05:38 PM
Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook Don Excel Discussion (Misc queries) 0 April 20th 08 04:51 AM
Using a workbook from 2003 in 2007 fda secretary Excel Discussion (Misc queries) 2 October 17th 07 07:33 PM
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO Andy Excel Programming 2 July 27th 07 10:44 PM


All times are GMT +1. The time now is 02:16 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"