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.
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.
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.
--
Gary Brown
gary_brown@ge_NOSPAM.com <== to respond, use ge.com
"Chuck" wrote:
> 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.
>
>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks