Hi !

Originally Posted by
darls15
I am using a web-based system that exports data by automatically by opening a CSV file in Excel. There is no option to save the file first. The files I export are quite often too large and do not fully load due to the row limitation in Excel and need to remain in an Excel format.
Would anyone know if there's a way to have Excel split a file as it's loading to the a 2nd sheet, 3rd sheet and so on, if the row count exceeds say 1,000,000?
Nope, there is no option as Excel is very not a database software …
But to be opened in Excel even from Web the file is stored locally on the hard disk
- maybe in the Temp folder of current user, just check it out -
so a beginner level short VBA procedure can read this text file and split it if necessary …
Bookmarks