Hey everybody, I wasn't sure which sub-forum to put this in, so I decided to try in the general forum.
Currently, our site has an employee directory setup, where when you click on a person, a popup window shows, and one of the bits of information displayed are "nudge points". These are points we give out to employees who participate in company sponsored health
events.
The nudge points automatically display when the window renders, and the code is as follows:
<TR><TD>Nudge Points</TD><TD>
<%
On Error Resume Next
'This searches a spreadsheet for the first and last name of a employee and displays thier nudge points
Const adOpenStatic = 3
Const adLockReadOnly = 2
Dim cnnExcel
Dim rstExcel
Dim I
I = 0
Set cnnExcel = Server.CreateObject("ADODB.Connection")
cnnExcel.Open "FILEDSN=nudgex.dsn;"
...
Go to the complete details ...