developingprogrammer
asked on
determine total rows in Excel sheet (2003 or 2007)
hey guys,
i've got this code
Question: what's the best way to check if the excel sheet i'm looking at has 65536 rows or 1048576 rows?
Homework: i can't use Application.Version because Excel 2007 can also create Excel 2003 sheets (.xls) which has 65536. i can't use the extension name (or rather it's not that reliable) because if i'm detecting for .xls, what if there's an xlt? yes i can list down all the Excel 2003 extensions but doesn't seem very elegant.
i've got this code
Select Case penmExcelVersion
Case enmExcel2003
intLastRowOfSheet = 65536
Case enmExcel2007
intLastRowOfSheet = 1048576
End Select
Question: what's the best way to check if the excel sheet i'm looking at has 65536 rows or 1048576 rows?
Homework: i can't use Application.Version because Excel 2007 can also create Excel 2003 sheets (.xls) which has 65536. i can't use the extension name (or rather it's not that reliable) because if i'm detecting for .xls, what if there's an xlt? yes i can list down all the Excel 2003 extensions but doesn't seem very elegant.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER