Thanks Ron, I'll have a play this weekend and post back my success!

Regards, Rob

"Ron de Bruin" wrote in message
...
Hi Rob

See also
http://www.rondebruin.nl/csv.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Rob" wrote in message
...
Thanks Roger, plenty to get on with here.


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Rob

Lots of code to do this type of thing at Ron de Bruin's site
http://www.rondebruin.nl/copy3.htm

--
Regards
Roger Govier

"Rob" wrote in message
...
Hi,

Using Excel 2000, I have a weekly task to open 35 CSV files and to
merge the contents which is about 1000 rows in each into a single file.
Each file has a unique name and is in a specific directory.

What I'd like to do is have some code that would allow a dialog box to
appear, select the directory and for all the csv files in that
directory to be merged into one file.

I've searched the web but can't find any code to get me started, any
ideas?

Thanks, Rob