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!

Check the Rows.Count property, if it is greater than 100,000 then it is
2007!

--
__________________________________
HTH

Bob

"sleepp" wrote in message
...
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!

Genius! I never knew that worked.
Thanks!

"Bob Phillips" wrote:

Check the Rows.Count property, if it is greater than 100,000 then it is
2007!

--
__________________________________
HTH

Bob

"sleepp" wrote in message
...
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!

Hi friends

Our company has set xls as default file format in Excel2007 -this is to
avoid ignorant users sending xlsx files to users with older versions.
Skilled users can change default and do whatever.
Behavious of Excel is: Open a new file, it has 65k rows. SaveAs xlsx or
xlsm, it still has 65k rows, it goes into "compatibility mode". Here is
where rows.count will fail. Close the file and reopen, voila a million +
rows.

Best wishes Harald

"Bob Phillips" wrote in message
...
Check the Rows.Count property, if it is greater than 100,000 then it is
2007!

--
__________________________________
HTH

Bob

"sleepp" wrote in message
...
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!

You can check the file format

Start here
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"sleepp" wrote in message ...
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!

Can't you just check any worksheets Row.Count and/or Columns.Count property
to test the maximum limits?

MsgBox Worksheets(1).Rows.Count, Worksheets(1).Columns.Count

--
Rick (MVP - Excel)


"sleepp" wrote in message
...
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!

you can check for workbook.fileformat (see the help on XlFileFormat for the
different versions) and check the application.version

regards,

Jurgen


"sleepp" wrote in message
...
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!