ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import more than one sheet into excel (https://www.excelbanter.com/excel-discussion-misc-queries/67576-import-more-than-one-sheet-into-excel.html)

Chuck

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.


Gary L Brown

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.



Chuck

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