Macro for creating folder

  • Thread starter Thread starter RG
  • Start date Start date
R

RG

I have been asked to add a macro to creat a folder every
time a value is put into a field. (basically the last
name of an idividual where documents will be stored that
pertain to them)The last name is always in the same
column.
Is that possible, and what would it look like?
Thanks,
 
Hi

Assuming that its root folder exist (Here C:\Temp) then it's

Sub test()
MkDir ("C:\Temp\NewStuff")
End Sub
 
Back
Top