HI
I am trying to save a file as a CSV file into a specific location and the code i am using for some reason takes 3/4 of the file location andputs the rest as the filename.
Can anyone help![]()
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\SeymourJ\Desktop\Tasks\HondaExtractMacro" & "DealerExtract" & Format(Date, "yyyymmdd"), FileFormat:=xlCSV
Thanks
Jeskit
Bookmarks