Date format in macros
 

Hi
I am a novice trying to use the date in a filename (e.g. Dave20040827.xls)
The only format I can get the date in is 8/27/2004 which causes issues with
my file path.
How can I change the date format in VB?
Any suggestions would be appreciated.
Thanks

Date format in macros
 

Assuming datKey is set to the correct date or Now() then place thi
after the folder at the end of the path in your save code

"Dave" & Format(datKey, "YYYYMMDD") & ".xls"

Jorda

--
Message posted from http://www.ExcelForum.com

Date format in macros
 

I'll try that.
Thanks

"jordanctc " wrote:

Assuming datKey is set to the correct date or Now() then place this
after the folder at the end of the path in your save code

"Dave" & Format(datKey, "YYYYMMDD") & ".xls"

Jordan


---
Message posted from http://www.ExcelForum.com/