Copying Cells from CSV files in folder into one worksheet
 

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

Copying Cells from CSV files in folder into one worksheet
 

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

wrote:
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