+ Reply to Thread
Results 1 to 2 of 2

Import of Multiple Text Files

  1. #1
    Registered User
    Join Date
    01-21-2006
    Posts
    1

    Import of Multiple Text Files

    I am looking to import about 75 data files for data analysis. I want to load all of these files into the the same workbook using a macro. I am new to the macro scence and have only begun to teach myself VB. Each data file has two columns and they are tab delimited. I want to start each text file at line 19 and they are named emi1.txt, emi2.txt and then emi(2)1.txt emi(2)2.txt and so on for each experiment. Is there any way I can write a macro to read all of these files in and label the top of each column with the file name?

    This would be such a great help.

    Thanks
    Bob

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187
    yes you can.

    have a lok at the replies to Importing a .txt file issues . You should be able to work it out from there but if not ask for more help.

    regards

+ 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