Import Multiple files into separate sheets based on list

[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.

 

[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.

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

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