View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default 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"?