Hello,
I try to open a 27MB text file (~ 495670 rows) and import rows 495662 - 496665 to an Excel sheet. Too many rows to handle with the Wizard.
I would like to have a VBA sub to open file, fetch given rows, copy those to an Excel sheet and close text file. I have to do this for 300-400 text files that are numbered in ascending order but not necessarily continuously, that is 01,02,03,05,07 etc.
Thanks for the help.
Ari Bari
Bookmarks