Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
folder permissions with a macro
good day,
i am using the following code in a macro to make a folder (EmpName) before saving a file into the folder... EmpName is referenced from a cell in the excel file On error resume next mkdir "C:\Operations\HR\EmpName" On Error goto 0 when the folder is created, the folder permissions are not correct, so the user cannot save the file directly to the folder. technically, the user creates the folder so they are the owner, but they cannot save to the folder. as part of the macro, is it possible to assign folder permissions... ex. the folder created takes it's permission from the parent folder - in this case HR. thank you, jat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro selects folder | Excel Discussion (Misc queries) | |||
Macro Folder Not Opening on Start Up | Excel Discussion (Misc queries) | |||
Copy a folder by macro | Excel Discussion (Misc queries) | |||
Macro to create a new folder according to the month | Excel Discussion (Misc queries) | |||
Changing Macro Folder | Excel Discussion (Misc queries) |