ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing and splitting large text file (https://www.excelbanter.com/excel-programming/371577-importing-splitting-large-text-file.html)

JeffMelton

Importing and splitting large text file
 
I remember finding a macro that would fit a text file into excel by
creating new sheets after 65.5k, but I've lost it. Does anybody have
something that can do this for me? Thanks


Jim Cone

Importing and splitting large text file
 
http://support.microsoft.com/kb/120596/en-us
"Importing Text Files Larger Than 65536 Rows"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"JeffMelton"
wrote in message
I remember finding a macro that would fit a text file into excel by
creating new sheets after 65.5k, but I've lost it. Does anybody have
something that can do this for me? Thanks



All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com