View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default help on creating five folders

Drop one of the backslashes after the drive letter and put the last subfolder
name in double quotes:

MkDir "C:\Globe Photo Engraving\Jobs\" & Range("C3").Value & "\ART"





David Shoemaker wrote:

Private Sub Folders_Click()
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value \ ART
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value \ GCODE
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value \ LG1
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value \ LG3
MkDir "C:\\Globe Photo Engraving\Jobs\" & Range("C3").Value \ LR2
End Sub

C:\Globe Photo Engraving\Jobs\("C3")\ART
G-CODE
LG1
LG3
LR2


--

Dave Peterson