Jeff,
No you can't not without upgrading to Excel 2007. But if you can live
with multiple sheets having up to 65,536 rows each then there is a
solution.
I just did this for a project that has over 400,000 records in a 24hr log
file. This routine imports the records and automatically adds sheets as
needed. Since you cannot use more than 65,536 rows per sheet your only
choice is to upgrade to Excel 2007 or to use multiple sheets.
The original subroutine was written by Chip Pearson and can be found
here:
http://www.cpearson.com/excel/ImportBigFiles.htm
ImportBigFiles is the routine you want along with the accompanying
Function - IsFileOpen to verify that the file you're opening is not
in-use.
His routines work nicely and the documentation he includes is like reading
a "How To" manual - excellent. These routines are now embedded in the
project workbook which will run without any changes in both Excel 2003 &
2007. So if you do upgrade later, it will still work.
Bob S.