Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
paul paul is offline
external usenet poster
 
Posts: 249
Default how many times a document is viewed

Is it possible find out how many times a word document has been opened ? or
is anyone able to advise how to set this up using VBA - maybe to record it in
an external txt or xls file.

Paul
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default how many times a document is viewed

On Thu, 19 Nov 2009 16:36:01 -0800, Paul
wrote:

Is it possible find out how many times a word document has been opened ? or
is anyone able to advise how to set this up using VBA - maybe to record it in
an external txt or xls file.

Paul


You could adapt the method shown in
http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- just change
the macro name from AutoNew to AutoOpen, and eliminate the two lines
of code

ActiveDocument.Bookmarks("Order").Range.InsertBefo re Format(Order,
"00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")

and don't bother putting the bookmark into the document.

The drawback is that not everyone allows macros to run on their
machine, and copies of the document may not be connected to the
original template. So the count could easily be too small and you'd
have no way to know.


--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
  #3   Report Post  
Posted to microsoft.public.word.docmanagement
paul paul is offline
external usenet poster
 
Posts: 249
Default how many times a document is viewed

Thanks - this looks like it will do what i need.

Paul

"Jay Freedman" wrote:

On Thu, 19 Nov 2009 16:36:01 -0800, Paul
wrote:

Is it possible find out how many times a word document has been opened ? or
is anyone able to advise how to set this up using VBA - maybe to record it in
an external txt or xls file.

Paul


You could adapt the method shown in
http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- just change
the macro name from AutoNew to AutoOpen, and eliminate the two lines
of code

ActiveDocument.Bookmarks("Order").Range.InsertBefo re Format(Order,
"00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")

and don't bother putting the bookmark into the document.

The drawback is that not everyone allows macros to run on their
machine, and copies of the document may not be connected to the
original template. So the count could easily be too small and you'd
have no way to know.


--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
date changes from that typed on original when document viewed Puzzled Microsoft Word Help 2 April 29th 07 10:39 AM
My printed document is much larger than the viewed document. jimz Microsoft Word Help 2 November 23rd 06 10:34 PM
Document opens "off-screen" and cannot be viewed Lois Microsoft Word Help 2 October 27th 06 05:01 PM
Pages increase almost to 8 times when viewed in Print Preview Eshhrath Microsoft Word Help 1 September 14th 05 01:31 AM
Privacy - clearing viewed document history in WORD imjoe007 Microsoft Word Help 0 January 18th 05 04:55 PM


All times are GMT +1. The time now is 08:13 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"