I am looking for a way to check if a directory exists on a
machine. If it dosn't I want to create it.

Can anybody help?

Hi Keith,

On Error Resume Next
MkDir "C:\YourNewFolderName"
On Error GoTo 0

---
Regards,
Norman



"Keith" wrote in message
...
I am looking for a way to check if a directory exists on a
machine. If it dosn't I want to create it.

Can anybody help?

Hi Keith
On Error Resume Next
ChDir "C:\Papou"
If Err < 0 Then MkDir "C:\Papou"

HTH
Cordially
Pascal

"Keith" a écrit dans le message de
...
I am looking for a way to check if a directory exists on a
machine. If it dosn't I want to create it.

Can anybody help?

Well, I've coded that way :

Set a = CreateObject("Scripting.FileSystemObject")

If a.folderexists("c:\temp") Then

Else
a.createfolder ("c:\temp")
End I

--
Message posted from http://www.ExcelForum.com