how many times a document is viewed

[Paul]

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

 

[Jay Freedman]

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.InsertBefore 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.

 

[Paul]

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

Paul