R Ross Feb 2, 2004 #1 How can I determine that a directory exists, it is valid. For example: Is "C:\imports\" a valid directory? Thanks
How can I determine that a directory exists, it is valid. For example: Is "C:\imports\" a valid directory? Thanks
C Cheryl Fischer Feb 2, 2004 #2 Ross, Here is one way to do it: If Len(Trim(Dir("c:\imports", vbDirectory))) > 0 Then MsgBox "folder exists" End If hth,
Ross, Here is one way to do it: If Len(Trim(Dir("c:\imports", vbDirectory))) > 0 Then MsgBox "folder exists" End If hth,
T TC Feb 3, 2004 #3 But whack an On Error around it, just in case the path contains an invalid drive letter (for example). TC
But whack an On Error around it, just in case the path contains an invalid drive letter (for example). TC
