MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Save As" Macro

Posted by Scott on December 06, 2001 7:48 AM


I have two questions:

Can anyone tell me how to write a macro to automate the changing of a .xls file to a .csv file? I have tried to do this by recording a macro, but can't get it right....perhaps some code?

Also, when converting a .xls file into a .csv file, the following happens: in each instance where there is a comma in the .xls file, double quotes appear when the transition is made to the .csv file. Any way to get rid of this? Thanks guys, any help would be greatly appreciated.

Posted by Mike on December 06, 2001 10:54 AM

ActiveWorkbook.SaveAs fileFormat:=xlCSV