Dear All,
I trust that this message finds you all in good health & wealth. I need your help on this matter:-
I have a large tab delimited text file with more than 75,000 records. I'd like to import it into multiple worksheets with each sheet containing not more than 30,000 records. I will manually create additional worksheets before starting the import job so you don't have to worry about that.
Excel's Import Wizard says it can be done but there does not seem to be a proper way to do it.
I'm looking for a VB macro to do this.
Thank you for your guidance.
ROBERT RAM
I trust that this message finds you all in good health & wealth. I need your help on this matter:-
I have a large tab delimited text file with more than 75,000 records. I'd like to import it into multiple worksheets with each sheet containing not more than 30,000 records. I will manually create additional worksheets before starting the import job so you don't have to worry about that.
Excel's Import Wizard says it can be done but there does not seem to be a proper way to do it.
I'm looking for a VB macro to do this.
Thank you for your guidance.
ROBERT RAM