![]() |
Import more than one sheet into excel
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. |
Import more than one sheet into excel
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 <== 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. |
Import more than one sheet into excel
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. |
All times are GMT +1. The time now is 05:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com