i've got this code
Select Case penmExcelVersion
intLastRowOfSheet = 65536
intLastRowOfSheet = 1048576
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.