Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Excel and File Security

Status
Not open for further replies.

msstrang

Programmer
Sep 19, 2005
62
US
Hello All,
I've been working on this issue for 2 days now and can not come up with a good solution, please someone point me in the right direction...

When using VB6 to save an excel file the creator of that file has ownership of the created file. This allows for the creator of the file to delete the file.

I have an application I've written that saves an excel file to a folder whose permissions for the "users" group is read and write only (no modify).

However, since the particular user was logged into the machine they will now have ownership of that file, and if they wanted could give themselves modify privelidges.

This is not good as this data needs to never be deleted once it is created by the VB6 application.

I've tried everything to get around this. Changing the ACL and ACE. Trying to remove the user who created the file as the "owner" (unsuccessfully). I've also tried to open excel as an admin, that way when the file is saved the admin is the owner (couldn't use the getobject() when I did this)

Please Please Please someone help me. I'm going insane here!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top