ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for creating folder (https://www.excelbanter.com/excel-programming/286415-macro-creating-folder.html)

RG[_2_]

Macro for creating folder
 
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,


Harald Staff

Macro for creating folder
 
Hi

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

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

--
HTH. Best wishes Harald
Followup to newsgroup only please

"RG" skrev i melding
...
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,





All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com