Import more than one sheet into excel

[Chuck]

I create a tab delimited file on and HP3000 and import it successfully
into Excel. What ascii or oct or hex character can I put in the file
so when I import it i can have multiple sheets in the excel file.

 

[Guest]

Chuck,
I've put together a workbook that was designed to import more that 65,000
lines of text by splitting it into multiple worksheets. It will import the
data into worksheets of user-specified lines. For example: if you have
10,000 lines of data (or 300,000 lines), you can split the data into 2,000
lines per worksheet if you want.
If you'd like, I will email you the workbook.

 

[Chuck]

Thanks. I don't think that's what I'm looking for. I need to create a
file on the main frame and when I e-mail it to the user I need the
multiple worksheets already created. There has to be no user
intervention. I guess I need to find the correct ascii or whatever
codes needed to let Excel know there are multiple sheets.