Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Hit Counter Odbc Source Browser Viewed

Author  Topic 

gwiegel
Starting Member

1 Post

Posted - 2008-06-22 : 21:30:31
I have an Excel file that has an ODBC connection as a data source. I need to know how many times the file has been viewed. I wrote SQL code in the onopen procedure that opens a second Excel file and enters now(). This works great when I open the file in Excel, but the file is part of a Visual Studio project and I don't know Visual Studio at all. Normally the file is viewed by clicking a <href link and it's viewed in the Browser. When that happens the file is Read Only and the macro doesn't work. Any suggestions would be appreciated. Thank you.
   

- Advertisement -