From Word to SQL server

[Terry]

Hi all,

Could anyone provide a pointer for the following situation?

I have an ambitious idea to generate some stats about Word usage within the
company. I've found an article on MSDN which tells me how to control Word
Application events. What I'd like to do is send a few bits of data
(filename, date, loginID etc) back to a SQL server db when certain
application events fire.

Anybody have any similar experiences they can share?

Thanx in advance

Terry

 

[Terry]

hi Rob,

I'd like to generate some stats about Word usage within the company,
ie,
template usage
new files created/existing files updated
prints submitted
most frequent users
etc...etc

in short, i want to generate an overall picture of how Word is being
utilised within the firm.

Terry

 

[Rob Schneider]

hi Rob,

I'd like to generate some stats about Word usage within the company,
ie,
template usage
new files created/existing files updated
prints submitted
most frequent users
etc...etc

in short, i want to generate an overall picture of how Word is being
utilised within the firm.

Terry

I'm not an expert and I don't have access right now to go look at the
server ... buy my hunch is that you can get this from server logs?

 

[Cindy Meister -WordMVP-]

Hi Terry,

Better place to pursue this would be a group such as Word.vba.general. This
is an end-user group, which means you won't encounter many people who even
understand what an "application event" is

Basically, you should be able to do this. Probably using an ADO connection,
preferably to a stored proc. But application events, especially if you want
them to be firing all the time, can be rather tricky things.

I have an ambitious idea to generate some stats about Word usage within the
company. I've found an article on MSDN which tells me how to control Word
Application events. What I'd like to do is send a few bits of data
(filename, date, loginID etc) back to a SQL server db when certain
application events fire.

Anybody have any similar experiences they can share?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail