Skip to content

Make Folder (Create Directory) in Access VBA

Function MakeFolder(strPath As String)
    On Error GoTo MakeFolder_Err
    If Dir(strPath, vbDirectory) > vbNullString Then
        Exit Function
    End If
    MkDir strPath
    MakeFolder = True
    Exit Function
    MsgBox "Folder """ & strPath & """ cannot be created."
    MakeFolder = False
End Function

This function creates a directory given a full path string. Note that the enclosing directory needs to exist for this to work. If the directory already exists, the function has no effect.

Your rating: None Average: 5 (1 vote)


creating multiple directories using VBA

August 1, 2014 by Anonymous, 11 weeks 3 days ago
Comment id: 52

This is nice article to create the new folder. Here is another article for create multiple directories. For create multiple folder using VBA code "create multiple folder "


September 7, 2012 by Anonymous, 2 years 6 weeks ago
Comment id: 17

Worked great! Thanks :)

Reply to comment

November 30, 2012 by Anonymous, 1 year 46 weeks ago
Comment id: 22

Heya just wanted to give you a quick heads up and let you know a few of the pictures aren't loading correctly. I'm not
sure why but I think its a linking issue. I've tried it in two different browsers and both show the same results.

Also visit my homepage: Hemorrhoids

Thank you!!!!!!

March 17, 2010 by Anonymous, 4 years 31 weeks ago
Comment id: 4

Thank you!!!!!!

Reply to comment

February 21, 2014 by Anonymous, 34 weeks 3 days ago
Comment id: 46

Hello, I enjoy reading all of your article post. I wanted to write
a little comment to support you.

Feel free to surf to my weblog :: kiev revolution live

Reply to comment

August 14, 2012 by Anonymous, 2 years 9 weeks ago
Comment id: 16

I have read a few good stuff here. Certainly worth bookmarking
for revisiting. I surprise how much attempt you set to make any
such great informative site.
Feel free to surf to my web-site seo analyse der webseite

Reply to comment

May 8, 2013 by Anonymous, 1 year 23 weeks ago
Comment id: 32

My partner and I stumbled over here coming from a different website and thought I may as well check things out.
I like what I see so now i'm following you. Look forward to finding out about your web page yet again.

Take a look at my web page

Reply to comment

January 31, 2014 by Anonymous, 37 weeks 3 days ago
Comment id: 42

Ich soll sagen, ich bin beeindruckt. Sie haben in Ihrem Artikel den Nagel auf den Kopf
getroffen. Das Problem ist, dass man derart zahlreiche verschiedene Meinungen
findet und es dann kompliziert ist, einen objektiven Einblick zu haben.
Ich bin froh, diesen Artikel gelesen zu haben.

Reply to comment

August 1, 2012 by Anonymous, 2 years 11 weeks ago
Comment id: 13

Dear writer ,

I am on your web blog , partly as I'm interested in your theme apparently although in addition for the reason that I'm in the course of figuring
out English as a 3rd tongue and was recommanded at some stage in my class to visit boards and internet blogs in order to rehearse writing comprehensive and "healthy" english.

I was brought to your website my Rakish, whom I believe has furthermore commented at this place nevertheless
I can't locate where (it does not in fact matter still). He informed me that you were the total "ruler" about this . He was correct!

I have a bit of a testing time (possibly this is because of my awareness of English which is not so comparable to yours, in that circumstance I am sorry) understanding your next argument while it looks to me (once more, if I am the one who is wrong , I ask for forgiveness) that on the whole of what is put on the web goes in opposition to what you are writing . Even you appear to be writing the reverse precisely 2 lines lower!

Except what I brought up above, everything you put in writing would seem fairly evenhanded to me and makes faultless meaning, that is why I am so mystified. It's likely I am just not fairly
comprehending what you in truth imply to communicate via your composing .

So far as your page by itself is concerned, I in fact appreciate how simple you made your menus
and how straightforwardly your information is read (selection
of colours for copy and background, dimension of characters …) I love the
way you put in writing, that I would describe as being
exact, done nonetheless not utilizing a lot of words (I suppose the expression is concise?

All my gratitude for taking the time to put in writing innovative quality subject matter
as it's always getting ever more exceptional as of late.


PS would you mind if I linked to your web blog from my own as we disclose alike declarations in distinct languages (mine is in Mandarin).
Here is my website baltimore md movers