• 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.

Email notification about copying

V

Villalobos

Active Member
Hello,

I would like to ask whether there is a VBA way to get email notification when the .xlsm file was copied (who, when, name of new filename, path of the copied file)? If this is not possible, that it is possible to get a notification when the copied file was opened at the first time (who, when, name of new filename, path of the copied file)?

Thanks in advance the reply!
 
I don't think excel can help help you with the first idea. You might want to see if your shared location has some security settings that would help.

As for the second idea, you can add a worksheet with the file path that it's currently saved in, add some simple code to check this sessions path against that list. Call that on Workbook_Open().
 
Hi, Villalobos!
I don't think you could do any of the two things since if a user has read access to the original file, he just can drop into a pendrive, port it to another standalone computer not networked and without internet connection, and play all the time he wants (as long as he can, regarding what does the macros in the file actually might do), and nobody ever get advised about it.
However if access might not be so straight and direct, i.e., via a request or something alike, you IT support team may be able to implement the proper procedures to register the occurrence of the events you want to log.
Regards!
 
You must log in or register to reply here.
Back
Top