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

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