Search results for query: *

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 automatically populate a table with real time data from a DDE server?

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.

How do I store data coming from a live DDE server without going through Excel?

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

What is the best way of coding to automate a spreadsheet for the fastest possible excution? Right now this spreadsheet uses macros ectensively with calls to an application object.

How do I get excel to execute code as a macro that is compiled in VB 6 as a .exe? I need fast execution.

How do I take a complicated excel macro, compile it with a visual basic 6.0 compiler to an .exe file, and then get the spreadsheet to execute it?

I have two tables, Adult and Children with a one to many relationship. On a report I would like to have the name of the adult, and all the names of the children on one line. How can I accomplish that?