Click here to Skip to main content
15,880,503 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionProblem calling C++ DLL from Excel Pin
gvanto24-Mar-09 16:11
gvanto24-Mar-09 16:11 
AnswerRe: Problem calling C++ DLL from Excel Pin
Garth J Lancaster24-Mar-09 16:32
professionalGarth J Lancaster24-Mar-09 16:32 
QuestionRe: Problem calling C++ DLL from Excel Pin
gvanto24-Mar-09 16:38
gvanto24-Mar-09 16:38 
AnswerRe: Problem calling C++ DLL from Excel Pin
Garth J Lancaster24-Mar-09 16:48
professionalGarth J Lancaster24-Mar-09 16:48 
AnswerRe: Problem calling C++ DLL from Excel Pin
Garth J Lancaster24-Mar-09 17:19
professionalGarth J Lancaster24-Mar-09 17:19 
QuestionRe: Problem calling C++ DLL from Excel Pin
gvanto24-Mar-09 17:23
gvanto24-Mar-09 17:23 
AnswerRe: Problem calling C++ DLL from Excel Pin
Garth J Lancaster24-Mar-09 17:25
professionalGarth J Lancaster24-Mar-09 17:25 
GeneralRe: Problem calling C++ DLL from Excel Pin
gvanto24-Mar-09 17:35
gvanto24-Mar-09 17:35 
Hmmm that was a bit schoolboy of me not to spot that error, thanks Garth!

I've actually just built the same functionality in a C# dll, works like a bomb!

Now I have a little design problem: I'd like the function I call in the dll to KEEP a cell dynamically updated (it fetches a security's price
from a local db).

Two options:
1) Loop within excel and keep calling the dll function (which queries the db and returns the result)
2) Loop within the dll and *somehow* keep the value of the cell WHICH CALLED IT, up to date. (this is how bloomberg's API functions to keep excel cells dynamically updated, very nifty !

I'm thinking that efficiency-wise, 2) would be better (something tells me that having 200 cells repetitively calling a function will cause Excel to hang ... is my hunch correct?)

Best,
G

Find Your Dream Job in Australia, Free!
http://www.WebCV.com.au

GeneralRe: Problem calling C++ DLL from Excel Pin
gvanto24-Mar-09 17:36
gvanto24-Mar-09 17:36 
GeneralRe: Problem calling C++ DLL from Excel Pin
Garth J Lancaster24-Mar-09 17:43
professionalGarth J Lancaster24-Mar-09 17:43 
QuestionMSVCR90.dll and MFCVC90.dll as part of wiseinstaller installation Pin
Ramchandra.kk24-Mar-09 15:40
Ramchandra.kk24-Mar-09 15:40 
QuestionUsing CViewmemebers , CDocumentmemebers in CWinThread Pin
Piction24-Mar-09 13:06
Piction24-Mar-09 13:06 
AnswerRe: Using CViewmemebers , CDocumentmemebers in CWinThread Pin
led mike25-Mar-09 5:16
led mike25-Mar-09 5:16 
QuestionCombination Algorithm Pin
Michael Hildebrand24-Mar-09 10:50
Michael Hildebrand24-Mar-09 10:50 
AnswerRe: Combination Algorithm Pin
led mike24-Mar-09 11:23
led mike24-Mar-09 11:23 
GeneralRe: Combination Algorithm Pin
Michael Hildebrand24-Mar-09 11:28
Michael Hildebrand24-Mar-09 11:28 
GeneralRe: Combination Algorithm Pin
Rick York24-Mar-09 11:45
mveRick York24-Mar-09 11:45 
GeneralRe: Combination Algorithm Pin
Rick York24-Mar-09 11:30
mveRick York24-Mar-09 11:30 
GeneralRe: Combination Algorithm Pin
Michael Hildebrand24-Mar-09 11:38
Michael Hildebrand24-Mar-09 11:38 
GeneralRe: Combination Algorithm Pin
Rick York24-Mar-09 11:42
mveRick York24-Mar-09 11:42 
GeneralRe: Combination Algorithm Pin
Michael Hildebrand24-Mar-09 11:46
Michael Hildebrand24-Mar-09 11:46 
GeneralRe: Combination Algorithm Pin
led mike25-Mar-09 5:14
led mike25-Mar-09 5:14 
GeneralRe: Combination Algorithm Pin
Michael Hildebrand24-Mar-09 11:31
Michael Hildebrand24-Mar-09 11:31 
GeneralRe: Combination Algorithm Pin
led mike25-Mar-09 5:20
led mike25-Mar-09 5:20 
AnswerRe: Combination Algorithm Pin
bulg24-Mar-09 11:30
bulg24-Mar-09 11:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.