If you combine all the data into one worksheet in a new workbook, then you could
save that workbook as your CSV file.

Ron de Bruin has some code at:
http://www.rondebruin.nl/copy2.htm

that might get you started.



baxterr wrote:

I am trying to convert multi tabs excel file into csv. Can I get all the tabs
in csv format in a same file?

Tks

--

Dave Peterson