View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dmg dmg is offline
external usenet poster
 
Posts: 3
Default 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