I have this macro already set up to choose one .txt file from a folder and then import the data. What I want is to set it up so I can select multiple .txt files and it will go through them one by one and perform the exact same thing on all of them. I just don't know how to set up an appropriate loop. Thanks!
Please Login or Register to view this content.
This will build a table of values down the columns where batchID, etc are located. Use Ctrl-Click or Shift-Click to select multiple files
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Almost there. This basically takes the first file and imports the data from only that file down a number of rows equal to the number of files I selected. But it doesn't seem to open any of the other files I select. I also forgot to mention originally that the ranges where these values are going already have offset built into to them so I don't need the offset in the VBA code.Originally Posted by Bernie Deitrick
This will build a table of values down the columns where batchID, etc are located. Use Ctrl-Click or Shift-Click to select multiple files
Please Login or Register to view this content.
Last edited by twofooted; 09-12-2014 at 04:50 PM.
Oops - forgot to clear out the old file stuff
Add in text = ""
So this:
For i = iLB To UBound(myFile)
Open myFile(i) For Input As #1
Becomes this:
For i = iLB To UBound(myFile)
text = ""
Open myFile(i) For Input As #1
Awesome! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks