Hi rmellison

Try this
http://www.rondebruin.nl/csv.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"rmellison" wrote in message ...
I need to import a load of CSV files into one workbook so that I can have
everything in XLS format and tidy everything up. The problem is I need to do
this to lots of files, and for a lot of workbooks, and to do it manually
would take an age. Can anyone suggest a macro that can import CSV files into
my workbook, perhaps taking each file name and path from a list file?? Or
another method maybe?

Thanks in advance, and Happy New Year!