J
jatman
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
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