Microsoft Excel VBA Code to convert .xls file to .csv file

[tekvb1977]

I have an excel spreadsheet (.xls). I like to convert it to (.csv) format automatically. Not sure what would be the code in Excel VBA to do so. Any ideas, thoughts would be appreciated. Thanks.

J

 

[firefytr]

Hi there,

You can still use the same save feature, just change the syntax slightly...

ActiveWorkbook.SaveAs "C:\YourPathGoesHere\YourFileNameGoesHere.csv", FileFormat:=xlCSV

change out ActiveWorkbook for whatever workbook you're wanting to save.

HTH

-----------
Regards,
Zack Barresse