Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    We're just upgrading to Office 2007. We have over 1000 Word templates and as part of the conversion we want to build in some method of tracking how much & how often they're used. A couple of options I thought of were writing code to:
    - append 'date run' to a txt file (1 txt file for each template I guess) every time the template is run
    or
    - create a couple of custom doc properties in the template and modify their value every time the template is run to record both the date last run and the number of times run

    Does anyone have any other ideas?

    Thanks...
    Adri

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    [quote name='adri' post='767069' date='24-Mar-2009 11:45']We're just upgrading to Office 2007. We have over 1000 Word templates and as part of the conversion we want to build in some method of tracking how much & how often they're used.[/quote]
    Are these templates in a shared folder on a Windows server? In that case, you could enable file auditing on that folder (e.g., using whatever event corresponds to opening the file) and see whether the Windows event log captures useful information. This would be much faster than editing the code in each template.

    If that fails, updating an external file/database seems safer than making changes to the template itself; I suspect that in a shared template scenario, users may be asked to "Save As" to save the updated property if another user opened the template first.

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes, the templates are in a shared folder on the server. But they would be doing a File>New, not a File>Open, so do you think the file auditing could still work?

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    [quote name='adri' post='767337' date='25-Mar-2009 13:10']Yes, the templates are in a shared folder on the server. But they would be doing a File>New, not a File>Open, so do you think the file auditing could still work?[/quote]
    It's worth testing. When Word accesses the file, Windows may consider that to be opening the file. If not, perhaps there is another file access event that gives you what you need.

  5. #5
    Star Lounger
    Join Date
    Jun 2001
    Location
    Vancouver, Br. Columbia
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='jscher2000' post='767363' date='25-Mar-2009 22:07']It's worth testing. When Word accesses the file, Windows may consider that to be opening the file. If not, perhaps there is another file access event that gives you what you need.[/quote]
    I asked our network guy to check it out and apparently it does log it, so many thanks for the great suggestion...sure saved me a lot of work!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •