Creating and naming a folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a new folder and name it using the value in a field.

Can someone help?
 
Public Sub MakeFolder(ByVal FolderName As String)

MkDir FolderName

End Sub

Help in Access 2003 doesn't mention this, but my memory of earlier version
help files is that you can't create a new folder and a subfolder within it
in one step, e.g. MkDir "MainFolder/SubFolder" where "MainFolder" does not
already exist. A quick test seems to confirm this, I get a path not found
error if I try that. I believe you need to do it in two steps, e.g. MkDir
"MainFolder" then MkDir "MainFolder/Subfolder".

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Thanks Brendan.

Brendan Reynolds said:
Public Sub MakeFolder(ByVal FolderName As String)

MkDir FolderName

End Sub

Help in Access 2003 doesn't mention this, but my memory of earlier version
help files is that you can't create a new folder and a subfolder within it
in one step, e.g. MkDir "MainFolder/SubFolder" where "MainFolder" does not
already exist. A quick test seems to confirm this, I get a path not found
error if I try that. I believe you need to do it in two steps, e.g. MkDir
"MainFolder" then MkDir "MainFolder/Subfolder".

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
Click to expand...
 
You can do it if you use the FileSystemObject to check for the existence of
the folder and then mkdir if it does not exists


If Not fs.FolderExists("C:\data\" & strCompanyDir & str2) Then 'directory
not found
MkDir "c:\data\" & strCompanyDir & str2
End If
 
Did you test that, Andrew?

Using FSO (which I don't see the point of, since the Dir function will check
for the folder existence just as well, without the requirement for an added
reference) will have no impact on whether the MkDir statement can create
multiple levels of subfolders simultaneously,
 
Back
Top