• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Update shared file on server

S

ssuresh98

Member
Hello All,

I have a macro which updates a file on the server on a daily basis. This is a shared file which many users will access.

1) I would like this file to open as "Read Only" (without prompt) when an end-user accesses it.

2)And I would like the macro to be able to update even if someone by mistake left the file open.


Is this possible? Can you please help with the VBA code that I can add to my macro to achieve this?


Thanks in advance
 
Just wanted to reword my request.

I have a file on the server which I update by a VBA macaro every day. End users use this file to lookup information. I would like to be the "owner" of the file and attribute "read only" access to end users. The problem is, if end-users forget to close the file, the macro which updates the file everyday does not work. Can you help me with a VBA solution for this?


TIA.
 
Hi, ssuresh98!

More than an Excel issue it seems to be a network or IT security related problem. You should talk to your support guys to set proper attributes and permission to the file stored in the shared newtwork folder.

Regards!
 
Hi SirJB7,

Thanks for your reply. We all have read and write access to the particular folder in the server. Is there a way to save a file with the same name in the same location even though it is open elsewhere.


Thanks
 
You must log in or register to reply here.
Back
Top