importing the value of an integer variable from Visual C++ program to Excel

Krystian · November 6th, 2002, 11:43 pm

I am trying to import the value of an integer variable from Visual C++ program to a specific Excel file. I am still somewhat new at Visual C++...Could someone please help me out?

gotcpp · November 7th, 2002, 5:04 am

you want to call a C++ executable or dll from Excel and get the result back into the spreadsheet or you want to get a file which you can oprn in Excel. Just trying to understand

DominicConnor · November 8th, 2002, 6:08 pm

If you want to write to a file, then use the ODBC driver.DominiConnor

Ouyang · November 14th, 2002, 7:54 am

QuoteOriginally posted by: KrystianI am trying to import the value of an integer variable from Visual C++ program to a specific Excel file. I am still somewhat new at Visual C++...Could someone please help me out?You need to write a xll function in c++ for excel (see other threads on how to do that). Or you can write a dll function and output the integer to excel through vba. Keep in mind that "integer" in c++ is corresponding to "long" in visual basic and "short" in c++ matches "integer" in vb.

DominicConnor · November 14th, 2002, 8:30 am

Also that True is -1, usually.