Import Multiple files into separate sheets based on list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mma40 - 20 Sep 2007 16:46 GMT

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.

Reply to this Message

mma40 - 20 Sep 2007 18:01 GMT

> 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

Reply to this Message