Maximum Number of Rows to import
 

Help,

I am trying to import a Text file into excel using
VBA. Hoever the file size when open runs over the 65000
Rows allowed by Excel. Is there a way to expand the
number of cells in Excel 2000 (SR-1)?



You assistance will be greatly appreciated.

Maximum Number of Rows to import
 

Hi
no. 65536 is the max. If you need more you either have to split the
date on several worksheets or use a different application (e.g. a
database)

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
Help,

I am trying to import a Text file into excel using
VBA. Hoever the file size when open runs over the 65000
Rows allowed by Excel. Is there a way to expand the
number of cells in Excel 2000 (SR-1)?



You assistance will be greatly appreciated.

Maximum Number of Rows to import
 

No. sorry. 65536 rows is an absolute Excel limitation.

HTH. Best wishes Harald

skrev i melding
...
Help,

I am trying to import a Text file into excel using
VBA. Hoever the file size when open runs over the 65000
Rows allowed by Excel. Is there a way to expand the
number of cells in Excel 2000 (SR-1)?



You assistance will be greatly appreciated.