Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
How do I convert Dates from Text back to Date format using macros | Excel Programming | |||
Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming |