Find if a specific path exists on harddrive

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

Guest

I'd like to find out if a specific path exists before using Basic to write a
file to that path. Is there some way to check whether a path exists?
 
Try this

If Len(Dir("C:\DirName", vbDirectory)) = 0 Then 'Doesn't exist
MkDir "C:\DirName" ' will create the dir
End If
 

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

Error 52 finding if Path exists 7
Access Print Files from Query Results 0
Need function to determine whether a directory exists 2
Finding A Specific TreNode 6
Path Not Found error with fso.getfolder 1
VBA Access Mdule equvalant of if exist c:/path/file 1
How to determine if directory exists 2
Data data from a Data Table 6

Back
Top