+ Reply to Thread
Results 1 to 3 of 3

Import more than one sheet into excel

  1. #1
    Chuck
    Guest

    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.


  2. #2
    Gary L Brown
    Guest

    RE: 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
    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.
    >
    >


  3. #3
    Chuck
    Guest

    Re: 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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1