Copying Cells from CSV files in folder into one worksheet

[rkresser]

Hi Everyone,

I need to combine cells from some CSV files that are in the same folder
into one excel worksheet. I went to Ron de Bruin's page and I saw a
macro that does what I want to do but does it for excel files in a
folder http://www.rondebruin.nl/copy3.htm#header . I tried changing the
code by replacing "**.xls" with "**.csv" but this didnt seem to work.
Does anyone have any ideas?

Thanks,

Reece

 

[rkresser]

Found the answer on the same webpage referred to in message, no need to
respond.