VBA SaveCopyAs CSV

[Sushiboy]

I have the following code to which I am trying to SaveAs a copy in a drive as a CSV copy. However, I want to keep the original open as a master template. Basically how do I create a copy and THEN save that copy as a CSV file?

When I run the below code, the macro falls down at FileFormat:=xlCSVWindows. The error message says named argument not found.


Dim Path As String
Dim Filename As String
Dim DateStamp As String


DateStamp = Format(Sheets("DATES").Range("B3"), "yyyymmdd")
Path = "S:\Other\Personal"
Filename = "Prices"

ActiveWorkbook.SaveCopyAs Filename:=Path & Filename & DateStamp &
".csv", FileFormat:=xlCSVWindows

 

[dmt32]

Hi,
SaveCopyAs does not have the FileFormat argument. Using this method only allows you to save a file of the same type but with another name.

Use SaveAs Method in your code to change file type

Dave