Export to .csv

[Desi_bhai]

I am trying to create a macro that takes a workbook that has multiple worksheets and saves all the worksheets as .csv files.

Please Login or Register  to view this content.

When I do this, I get an error:
"Method Save As of object '_WorkBook' failed"

[macroDummy]

hello.

here you go. Your qn had been answered in another thread.
i hope this help.

http://www.excelforum.com/showthread...e+excel+format

lily