![]() |
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, |
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