create folder if it doesn't already exist

[lala]

how can i do that?
i'm using mkdir to create a folder
but if it's already there, i'm getting an error message

so how can i first check if the folder already exists, and if not, then create it

thank you!!

 

[boblarson]

scratched due to code error. See next post.

 

[boblarson]

Sorry, made a mistake with that one, it needs to be:

If Dir("YourFolderPathHere", [COLOR="Red"]vbDirectory[/COLOR])= "" Then
    MkDir("YourFolderPathHere")
End If

 

[lala]

thank you!!!!!!!!!!!


just trying to learn something, what does VBDirectory do?

 

[boblarson]

thank you!!!!!!!!!!!


just trying to learn something, what does VBDirectory do?

Tells it you are trying to find a FOLDER and not a file.

 

[lala]

ok, so if i WAS trying to find a file, then what would it be?
vbFile?

 

[boblarson]

ok, so if i WAS trying to find a file, then what would it be?
vbFile?

Nope, just leave it off completely:

If Dir("C:\Temp\MyFile.xls")=""

etc.

 

[lala]

thank you so much!!!!!!

 

[boblarson]