Use the value 6 instead of xlCSV.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Perico" wrote in message
...
I'm running this code FROM ACCESS using automation to run Excel. Am
trying
to save the Excel file I create as a csv, but the xlCSV is not recognized:

xlWbMst.SaveAs Filename:=fNameMst, FileFormat:=xlCSV

How do I save my Excel file as a true csv file running the code in Access
using automation if the above does not work. Need help quickly please.