Creating directories from excel
Hi Kevin
The Dir function test the existence of the folder (works for file as well)
MkDir create the specified directory
Sub test()
If Dir("C:\TempTest\") = "" Then
MkDir ("C:\TempTest\")
End If
End Sub
Regards,
Jean-Yves
"Keivn Green" wrote in message
...
I would like to create a directory using a macro which is easy enough, but
how can I have it verify whether or not its there?
would it be "if dir: blablabla = true then"?
|