Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 workbook for 2003 client | Excel Discussion (Misc queries) | |||
excell workbook 2007 to 2003 | Excel Discussion (Misc queries) | |||
Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
Using a workbook from 2003 in 2007 | Excel Discussion (Misc queries) | |||
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO | Excel Programming |