Last post Jun 26, 2008 02:42 PM by AlexB1318
Jun 21, 2008 10:24 PM|gwiegel|LINK
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.
Jun 26, 2008 02:42 PM|AlexB1318|LINK
If you enable logging on the website you can look at the log files that are generated to get your counts. They'll show how many Gets occurred on the file in question. You have to parse the file(s) or import them into Excel or some database...just a suggestion
on an alternative way to get your counts.