How to determine version/file-format of file and num of max rows allowed of this file

Hi,

I have a problem i am hoping someone can help me with. I have a macro which reads in a file. This file comes from 5 different users and all the users have different excel versions from excel 2003 to excel 2010.

When i read in the file i want to check the number of rows used in the file. If for example someone who uses excel 2003 sends me a file and there are ~65,536 rows populated with data then i want send an alert to the screen saying something like "you are using the max number of rows in the file" please verify that you have populated the file correctly.........

the problem is i am not sure how to do this? if i use the version ....the program just returns the version from which the macro is running.......which is not going to work because the person running the macro always uses excel 2010.

Anyone have any ideas? also, if i have not explained this well please let me know and i will try to do better.

Hi,

just check Worksheet.Rows.Count …

rows.count wont work for the reason PMFDibbins mentioned.

i am kinda stumped on this one.

no the people keep changing.......but good thought.....i guess there is no way to do this.

what do you mean by source of files stay the same? Not sure what you mean.......

using rows.count wont work.........

if i save an excel 2003 file (where max rows is ~65k) and then run macro using my 2007 version the rows max value is not the 2003 limit but the 2007 limit.

ok, i will try it. can someone send me an excel file created with excel 2003?

You can create one yourself with Save As of 2007 (and above), basic Excel knowledge …

See Attached

As usual you guys are right..........

I just ran the following test. I am running excel 2007.

From an xl2007 test macro i created I opened one of the xl2003 xls file sent to me. I then used the code

Please Login or Register  to view this content.

to identify the number of rows in the worksheet.........and the value shown was

65536


GREAT!!!!!!!! It worked!!!!!!!!!!!

Thanks guys.........as always your great!!!!!!!!!!

As I wrote 3 weeks ago in post #2 ! …