I'll explain from the begining. I have a third party thin client on my computer. This client logs into a remote server with a user name and password. Once logged in, I receive live prices from it. The problem is the connection is lost frequently, and I am not always their to log back on. I...
No, it is not in the registry. I have a couple of these. They stream live price data into excel. The one I need to monitor was written in Java, and I do have documentation for its methods. Without a ProgID, however, I have no idea how to capture it in a com. Can anyone help point me in the...
I need to write an application that monitors a third party server that streams data. This third party application does not have a ProgID. I need to be sure that this server is up, and if the connection is lost, I need to be able to log back in.
I have always used a ProgID for automation in...
How do I store data into a sql server table coming from a live DDE server without going through Excel? This is a live data feed of stock prices. I need to database a history of prices for anaylsis purposes.
I want to store the info in an sql server database. I do not know how to get the data directly into sql. Right now I am gathering the data in excel, and then using DTS to populate the table. I am sure that there is a better way of doing this, I just don't know how.
I have been using the wrox series of books, starting with begining C++ through Professional ATL COM Programming. The is also information in the MSDN knowledge base.
To get you at least started, on the menu of C++ use file, and new. Not the icon. You will get a dialog box. On the project...
Now you are talking about automation. It is a whole different ball game. You need either a MFC project, or an ATL project with MFC support. You need to use MFC it import the appropriate library as a class. Then you can invoke the methods.
Let me know if you need more info.
I wrote a com in vc++ to execute an excel spreadsheet every minute. This spreadsheet also uses an add-in that is a DDE link. It works well, except that intermittently I get an excel unknown exception, and excel terminates. This happens ever 1 to 2 hours.
Does anyone know how I can find out...
I wrote a com to execute an excel spreadsheet every minute. This spreadsheet also uses an add-in that is a DDE link. It works well, except that intermittently I get an excel exception, and excel terminates. This happens ever 1 to 2 hours.
Does anyone know how I can find out what is causing...
I have an Excel spreadsheet with a lot of data. This data needs to be crunched, and returned to the sheet so graphs can be created. To accomplish this I wrote a ATL COM in C++ 6.0. To manipulate the data, from the main function I call private void functions and passes the data through...
I have an Excel spreadsheet with a lot of data. This data needs to be crunched, and returned to the sheet so graphs can be created. To accomplish this I wrote a ATL COM in C++ 6.0. To manipulate the data, from the main function I call private void functions and passes the data through...
I have an extensive Excel spreadsheet with many references and calculations. To ease the load, I want to write a c++ program to read the data into a one dimentional array of structs, do some sorts and some calculations, and then spit the data back out to a separate part of the spreadsheet. If...
I have an extensive Excel spreadsheet with many references and calculations. To ease the load, I want to write a c++ program to read the data into a one dimentional array of structs, do some sorts and some calculations, and then spit the data back out to a separate part of the spreadsheet. If...
I'm new to automation. I have my wrapper for excel, and I can fill the safearray. Now I need to manipulate the data before putting it back on the excel sheet, and I can't seem to access the data. So far, I have only used C++ academically. Professionally, my experience has been in VB and ASP...
I'm new to automation. I have my wrapper for excel, and I can fill the safearray. Now I need to manipulate the data before putting it back on the excel sheet, and I can't seem to access the data. So far, I have only used C++ academically. Professionally, my experience has been in VB and ASP...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.