S
sleepp
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!
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!