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