Use the value of the Excel constant which is 6.
If you still have problems then do not use named arguments.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"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.