Can you count how many times a macro has been ran over multiple of the same file?

[Bassie]

Hi,

So bit of a strange question, I created a macro that I distributed to 6 teams. Now to calculate impact of my macro I would like to add a feature in the newer versions that counts how many times the macro has been ran. However, every team will use their own version of the macro (so not the same file). Is this even possible? I was thinking about automatically sending an e-mail to me ones the macro has been ran but that sounds way over complicating the issue (they also don't work on the same shared drive, that was my first solution)

Regards,

 

[Joe4]

Is there any common network drive/share that everyone has access to?
If so, you can place an Excel file out there as a sort of a Log file, and have your Macro write to it everytime it runs.
It would simply open the file, add a new row with details of who ran it and when, then save and close the file.

 

[Bassie]

Is there any common network drive/share that everyone has access to?
If so, you can place an Excel file out there as a sort of a Log file, and have your Macro write to it everytime it runs.
It would simply open the file, add a new row with details of who ran it and when, then save and close the file.

Hi, Thanks for your reaction!

This is unfortunately not possible as the teams are part of different parts of the organization and thus have different shared drives.

 

[nemmi69]

Only other way I could see is write to an INI file or a variable in the registry

 

[Bassie]

Only other way I could see is write to an INI file or a variable in the registry

Not sure I have the required knowledge at the moment to do this but I will look in to it thank you for the suggestions!

 

[Joe4]

Hi, Thanks for your reaction!

This is unfortunately not possible as the teams are part of different parts of the organization and thus have different shared drives.

You could have each write to some drive in their own environment (maybe log a single row text file for each run(, and then have something on company network server collect them every night and aggregate them into a single workbook.