Send User Information to SQL Server On Open

[Raul]

I have a number of training documents on a server (some may end up in a
sharepoint document library) and I need to know when a document is opened and
who opened it in an effort to track employee training records. I would like
to include some vba code in the documents that sends the document name, the
user name, computer name, and the date to a SQL Server database whenever the
document is opened.

Can anyone help me with getting the username and computer name? I can use
all the help I can get. I'm also open to other suggestions on how to handle
training records.

Thanks,
Raul

 

[Raul]

I found the following link to the information I needed on the Excel
Programming page.

http://blogs.officezealot.com/charles/archive/2004/12/10/3574.aspx

Charles Maxon's blog described the use of the ENVIRON function which met my
needs.

Raul

 

[Net_prof]

I'm not so sure you are mixing the rhetorical apples and oranges here.

The ENVIRON function you referenced will allow you to read the users
settings on the their workstation and get user and workstation information.

You need to check into the AUTO_OPEN subroutine in Word to define a process
that will automatically fire when you open a document.

Thanks,

net_prof