HI,
I am currently saving a file as an Excel Workbook (*XLSX) with today's date using this VBA code:
I want to change this to now be able to save the file with today's date but as a CSV file - CSV (comma delimited) (*.CSV)ActiveWorkbook.SaveAs Filename:="M:\Beaufort ACS\BACS Operations\Operations\Additional Prices\" & Valuation & "Additional Prices " & Format(Date, "ddmmyyyy")
But can't find the correct way to do it.
Any help as always is very much appreciated.
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)