Hi!
I am working with DDE application that links Excel with a website on a remote server.
The website sends messages and that application inserts them into Excel.
THE PROBLEM: each new message overwrites the previous, without creating any logs. I did not write the Excel app, and don't know how it works.
DESIRED SOLUTION: AN APP THAT WOULD SAVE THE MESSAGES TO A DATABASE. ACCESS, SQL2K, ORACLE - DOES NOT MATTER.
Somebody suggested to write code to monitor socket activity and use it to "trigger" an SQL query on exhisting Excel file as datasource, grab data, insert into DB.
I am good with Databases and VB.Net, but weak on WinSock API side.
* How do you write code to raine an event based on WINSOCK activity?
* How do I distinguish that WINSOCK ACTIVITY IS RELATED TO message came form THAT site?
Any suggestions, please?
I am working with DDE application that links Excel with a website on a remote server.
The website sends messages and that application inserts them into Excel.
THE PROBLEM: each new message overwrites the previous, without creating any logs. I did not write the Excel app, and don't know how it works.
DESIRED SOLUTION: AN APP THAT WOULD SAVE THE MESSAGES TO A DATABASE. ACCESS, SQL2K, ORACLE - DOES NOT MATTER.
Somebody suggested to write code to monitor socket activity and use it to "trigger" an SQL query on exhisting Excel file as datasource, grab data, insert into DB.
I am good with Databases and VB.Net, but weak on WinSock API side.
* How do you write code to raine an event based on WINSOCK activity?
* How do I distinguish that WINSOCK ACTIVITY IS RELATED TO message came form THAT site?
Any suggestions, please?
