Create a folder with name generated automatically

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I would like to make a procedure for a form which creates
a folder with automatically generated name. For example,
if the current date is January 08, 2003 and the current
time is 11:00, the folder should be named
as "c:\Backup\080120031100"
Is it possible?
 
If you already have the parent dir "C:\BackUp", you can use:

mkdir "C:\BackUp\" & Format(Now(), "ddmmyyyyhhnn")

If you have got the parent dir, you need to create the parent dir first
(another mkdir).
 
Back
Top