want to save new folder as date
hello,
i'm trying to figure out how to use Word 2003 macros in order to automatically create folders while naming them today's date (ex. C:\17-06-2008), and save the active document in the new folder at the same time.
it should be possible to save a number of documents every day in the 'present day' folder (without giving the message that the folder already exist).
can anyone help me out?
thanks
Re: want to save new folder as date
To make "date" folders in correct order, you should name it as yyyy-mm-dd.
Code:
Dim sFolder as string
'...
sFolder = "C:\" & Format(Date,"yyyy-mm-dd")
If Dir(sFolder, vbDirectory) = "" Then
MkDir sFolder
End If
Re: want to save new folder as date
Thanks anhn
I'll try that. Now I want to save the active document in that date folder. i keep getting errors.