View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
karthik karthik is offline
external usenet poster
 
Posts: 48
Default Bring different .csv files in to one single Excel work book

I've been generating .csv files daily which contains data of 5 columns and
roughly 2000 rows. Could all these file be brought into one single Excel
work book with each day as a separate worksheet?

I tried downloading the ADD ins from http://www.rondebruin.nl/copy2.htm
but this add in merges all the files in one single work sheet.

Please let me know if anyone knows a way to automate it.

Thanks in Advance.....
--
Karthi