Hi,
I have a number of users using the same Excel template in folder A and I would like to have all users save their projects to folder B without being able to delete their own or others projects. I have tried to limit the users rights to “write but not delete” via security features in Windows Explorer, but this does not work due to the Excel temp file that is automatically created and deleted when using VBA workbook.SaveAs. Via VBA I am able to save the projects to a temp folder C where users have no restrictions and then copy the project to the destination folder B, but this is not a solution for the following reason: Users needs to be able to continue working and printing from the project, and for documentation purposes the prints must include the location of the file (folder B).
Does anyone have a suggestion on how to save the Excel project to folder B while being able to continue working with the project?
Squash
I have a number of users using the same Excel template in folder A and I would like to have all users save their projects to folder B without being able to delete their own or others projects. I have tried to limit the users rights to “write but not delete” via security features in Windows Explorer, but this does not work due to the Excel temp file that is automatically created and deleted when using VBA workbook.SaveAs. Via VBA I am able to save the projects to a temp folder C where users have no restrictions and then copy the project to the destination folder B, but this is not a solution for the following reason: Users needs to be able to continue working and printing from the project, and for documentation purposes the prints must include the location of the file (folder B).
Does anyone have a suggestion on how to save the Excel project to folder B while being able to continue working with the project?
Squash
