Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2013
    Posts
    40
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Import 4 Text files to different sheet

    Hello,

    I have 4 text files in a folder & format, structure of files are same.
    I want to import all 4 files simultaneously to a workbook with each text file having their own sheets.
    Any one, a macro for this.

    Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Carmine

    ..how about attaching some sample dummy text files that approximate to what you have?
    That way, we could more easily give you some code to do what you want.
    How do you want the sheets named???
    Do you always import to an 'empty' workbook???
    Or, what if you've already imported, do you want the data appended??? or new sheets again????

    zeddy

  3. #3
    Lounger
    Join Date
    Nov 2013
    Posts
    40
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Hello,

    I have attached the sample text file and excel workbook.

    I will import single text file and Column B will be the name of sheet. The data to be sorted on column B and then transferred to their group sheet.

    First line and last line of the text is not required.

    For more details please refer to attachment.
    Attached Files Attached Files

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Very similar to:

    http://windowssecrets.com/forums/sho...pend-and-Split

    You guys working on the same project?

Posting Permissions

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