drbtodd1971
Programmer
- Mar 28, 2007
- 34
I have the following code and keep getting errors because it appears to be defaulting to the default date setting which includes slashes.
How can I append the date without the slashes, I've tried formatting it in various ways but with no luck.
Dim dtMyDate As Date
dtMyDate = Format(Date, "DDMMYY")
ActiveWorkbook.SaveAs Filename:="C:\Temp\WinsfordWalkSheet2007Week_" & dtMyDate
How can I append the date without the slashes, I've tried formatting it in various ways but with no luck.
Dim dtMyDate As Date
dtMyDate = Format(Date, "DDMMYY")
ActiveWorkbook.SaveAs Filename:="C:\Temp\WinsfordWalkSheet2007Week_" & dtMyDate