+ Reply to Thread
Results 1 to 4 of 4

Extract data from multiple text files into individual columns

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Stoke, England
    MS-Off Ver
    2016
    Posts
    24

    Extract data from multiple text files into individual columns

    Hi,
    I'd like to extract data from all the text files in a folder into individual columns using VBA

    lets say 2 text files in this location "C:\Users\jonny\Desktop\test\" - textfile1 contains A,B,C and textfile2 contains D,E,F (each letter is on a seperate line in their respective text file) - I'd like the output to look like this:


    column A column B
    A D
    B E
    C E

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Extract data from multiple text files into individual columns

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Registered User
    Join Date
    01-28-2016
    Location
    Stoke, England
    MS-Off Ver
    2016
    Posts
    24

    Re: Extract data from multiple text files into individual columns

    that works great, thank you

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Extract data from multiple text files into individual columns

    You are welcome, glad to help.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Export Individual Rows To Individual Text Files?
    By jimmer18 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-13-2014, 11:43 AM
  2. Help importing multiple text files into individual columns
    By Jev1991 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 11:37 AM
  3. Outputting individual cells to individual text files
    By db9429 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2013, 03:39 PM
  4. [SOLVED] Need a Macro to grap individual data cells and check box data,Multiple files into single
    By Ghostwheel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2012, 04:42 PM
  5. [SOLVED] Creating a Macros to save individual columns as text files
    By lorigies in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2012, 05:18 PM
  6. Replies: 1
    Last Post: 04-09-2012, 09:21 AM
  7. Help importing multiple text files to individual sheets in an excel workbook
    By cham.miller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2010, 06:55 PM
  8. Replies: 1
    Last Post: 07-11-2006, 01:35 PM

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