code to convert excel worksheets into csv

[Happy YN]

I am posting this as a separate thread even though I had tagged it onto another thread as I fear it may be missed!
I would like to know whether there is any way for a module to convert all sheets of an excel file into csv. i.e sheet1 becomes csv1, sheet2 becomes csv2 etc. I have looked in a few places unsuccesfully and would appreciate anyone pointing me in the right direction!
Thanks

 

[Brianwarnock]

Shades replied on the other thread

Howdy, Check out the knowledge articles at www.vbaexpress.com Some of this is already written with directions on how to setup and use.

Brian