View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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