Create a folder....

P

Paiolas

Hi

I want to create a folder in a specific location, but
only if it doesn´t already exits!
I´ve tried the folowing code but it doesn´t work (i don´t
understand the "object")

If Object.FolderExists(ThisWorkbook.Path & "\" & "Temp")
= False Then
MkDir ThisWorkbook.Path & "\" & "Temp"
End If

Thanks a lot
Paiolas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Create Folder..... 1
How to avoid accessing template opening docs 3
Cannot Update Links ?? 0
Mail merge leaves excel process running 3
Error message 1004 2
Access to Excel format 2
Problems with VBA mailmerge 1

Top