Thread: Create Folder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Create Folder

On Error Resume Next
MkDir "C:\My Documents\Years\2009"
On Error Goto 0

--
__________________________________
HTH

Bob

"K" wrote in message
...
Hi all, I want macro which should create folder with name "2009" in
"C:\My Documents\Years" and if there is already folder with name
"2009" in "C:\My Documents\Years" then macro should do nothing.
Please can any friend can help