ActiveWorkbook.SaveAs Format(Date, €œmmddyy€�) & €œ.csv€�
 

Using Excel 2007 I'm getting an error message.


ActiveWorkbook.SaveAs "C:\Users\Michael Guergawi\Documents\€� & Format(Date,
€œmmddyy€�) & €œ.csv€�


what Am I missing?

Thanks in advance

ActiveWorkbook.SaveAs Format(Date, €œmmddyy€�) & €œ.csv€�
 

Try the below...The file format is to be specified

Dim strFile As String

strFile = "C:\Users\Michael Guergawi\Documents\" & _
Format(Date, "mmddyy") & ".csv"

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=strFile, FileFormat:=xlCSVMSDOS
Application.DisplayAlerts = True

If this post helps click Yes
---------------
Jacob Skaria


"LuisE" wrote:

Using Excel 2007 I'm getting an error message.


ActiveWorkbook.SaveAs "C:\Users\Michael Guergawi\Documents\€� & Format(Date,
€œmmddyy€�) & €œ.csv€�


what Am I missing?

Thanks in advance

ActiveWorkbook.SaveAs Format(Date, "mmddyy") & ".csv"
 

Would you like to share with us what the error message says?


"LuisE" wrote in message
...
Using Excel 2007 I'm getting an error message.


ActiveWorkbook.SaveAs "C:\Users\Michael Guergawi\Documents\" &
Format(Date,
"mmddyy") & ".csv"


what Am I missing?

Thanks in advance

ActiveWorkbook.SaveAs Format(Date, "mmddyy") & ".csv"
 

Thanks I just did what Jacob suggested and it worked

"JLGWhiz" wrote:

Would you like to share with us what the error message says?


"LuisE" wrote in message
...
Using Excel 2007 I'm getting an error message.


ActiveWorkbook.SaveAs "C:\Users\Michael Guergawi\Documents\" &
Format(Date,
"mmddyy") & ".csv"


what Am I missing?

Thanks in advance