Hello All,
VBA and Forum Newb here, thanks very much for the help I have acquired by browsing this site...being new to VBA I have been buried in techy/programmer websites all week...mainly doing this
Anyways, my problem
I provide a regular weekly report, using Excel 2003, to the company I work for (approx 100 users). I have been tasked with testing how much this report is opened and read (not just the Email with the report attatched, the Report itself)
I believe the ENVIRON User name function COULD be part of the solution (in that, it can acquire the user name) the tricky part is coding it in such a way that I as the sender am informed or a table is updated each and every time one of the users opens the sheet....
Apologies if this isn't how I should be asking for help...if you have questions, please let me know.
Thanks again for any previous or future help!!