VBA to Notify When Somebody Opens an Excel File?

[hellfire45]

So I am an analyst and I automate over 150 reports to people all over my company. I suspect that many people do not use the reports that I send and I would like to know which reports are not used so that I can turn them off.

Basically I am looking for VBA that will notify me, or maybe update a database someplace, when somebody opens an excel file. In this way, I can know which files are being used and which are not. Then if a file hasn't been opened by anybody in say 3 months, I can deactivate it.

Does anybody know of any good places to start on this? Maybe a VBA script that fires off when somebody opens a file. However, none of the files I distribute are macro enabled and it would be a tremendous effort to change them all. Still, I will take what I can get.

Please and thank you!

 

[mole999]

there is the conundrum, VBA deactivated and wanting a VBA Script (unless I mis understood) could the excel be ported to activedirectory/report server and have it tracked through use there

 

[hellfire45]

there is the conundrum, VBA deactivated and wanting a VBA Script (unless I mis understood) could the excel be ported to activedirectory/report server and have it tracked through use there

If I were to distribute this as a macro enabled report, would it be possible?

 

[mole999]

I've never done a centralised excel, I use an on load, write to xlhidden sheet, so I think it would be possible to do something like that.

You will face the issue if the user has macros disabled then nothing happens (you can make the book not work if macros are disabled)