Copy code from ThisWorkbook using VBA?
 

I have a master report template that I use, which loops through a series of
sites that I do reporting for and creates range/valued site level reports -
nice and small and easy to work with.

The requestor for this report wanted to know who is accessing these reports.
Right now, they are hosted on a Sharepoint site and statistics have not been
setup.

I have a simple routine that appends a log-file during the On Open event
that gives me the date, time, name of the file and user name.

However, this resides in the ThisWorkbook object and I don't know how to
programatically copy that code to each new workbook as they are created. I
need to get this code into each workbook so I can track who is using what
reports and when.

Grant it, I know that anyone who opens the workbook without macros enabled
won't be counted, but this is just for a rough baseline...

If any more information or snippets of code are required, let me know.

Thanks!
Ray
--
"Trying to make reports so easy... even a monkey could run ''em!"

Copy code from ThisWorkbook using VBA?
 

I bet you could find something here

http://www.cpearson.com/excel/vbe.aspx
--
HTH,
Barb Reinhardt



"RayportingMonkey" wrote:

I have a master report template that I use, which loops through a series of
sites that I do reporting for and creates range/valued site level reports -
nice and small and easy to work with.

The requestor for this report wanted to know who is accessing these reports.
Right now, they are hosted on a Sharepoint site and statistics have not been
setup.

I have a simple routine that appends a log-file during the On Open event
that gives me the date, time, name of the file and user name.

However, this resides in the ThisWorkbook object and I don't know how to
programatically copy that code to each new workbook as they are created. I
need to get this code into each workbook so I can track who is using what
reports and when.

Grant it, I know that anyone who opens the workbook without macros enabled
won't be counted, but this is just for a rough baseline...

If any more information or snippets of code are required, let me know.

Thanks!
Ray
--
"Trying to make reports so easy... even a monkey could run ''em!"