Import Multiple files into separate sheets based on list

  • Thread starter Thread starter mma40
  • Start date Start date
M

mma40

I have a list of file names in sheet1 of a workbook. I am trying to
figure out how to use a macro to go down the list and for each one,
add a new sheet, import the file, and rename the tab to the name from
the list, then move to next cell in sheet1 until all the files have
been imported. Can anyone give me a hand? My results keep trying to
take the cell down on the each newly added page.
 
I have a list of file names in sheet1 of a workbook. I am trying to
figure out how to use a macro to go down the list and for each one,
add a new sheet, import the file, and rename the tab to the name from
the list, then move to next cell in sheet1 until all the files have
been imported. Can anyone give me a hand? My results keep trying to
take the cell down on the each newly added page.
Click to expand...

Of course as soon as I posted the question, I found the answer at the
below address:

http://www.rondebruin.nl/txtcsv.htm
 
Back
Top