Thread: mkdir
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default mkdir

If Dir(save_path2, vbDirectory) = "" Then MkDir save_path2


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Peter" wrote in message
ups.com...
Does anyone have any idea why this doesn't work? I keep getting a Path
not found (Error 76) message and the mkdir (save_path2) part of the
code highlighted.

If Dir(save_path2, vbDirectory) = "" Then MkDir (save_path2)

Thanks,

Peter