Does the folder exist?
Function FolderExists(strFolderPath As String) As Boolean
On Error Resume Next
If Len(strFolderPath) 0 Then
FolderExists = ((GetAttr(strFolderPath) And vbDirectory) 0)
Err.Clear
End If
End Function
RBS
"Otto Moehrbach" wrote in message
...
Excel XP & Win XP
How can I determine if a specific folder, say "C:\The Folder", exists?
I have an OP who will be sending some files, and the code to place the
files in that folder, to some people. Thanks for your time. Otto
|