help on creating five folders

  • Thread starter Thread starter David Shoemaker
  • Start date Start date
D

David Shoemaker

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
 
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After getting value from a cell need to make five folders under th 1
How can I create five folders after this with a spacific name 1
Automaic Folder Numbering 1
creating a new folder with a value of a cell on the C directory 1
Hidden worksheet 3
Create folders from excel 2
Rename rather than overwrite existing file 4
No error message but code doesn't work 1

Back
Top