|
I am trying to access a c++ created DLL from within Excel, with semi-success only:
I've followed the following tutorial EXACTLY: http://newtonexcelbach.wordpress.com...ng-excel-to-c/
Now, when I try and use the dll-functions that I've declared in the VB code, the function GetPrice(), which takes no arguments and simply returns a number, works fine.
However, as soon as I create a dll-function which takes input arguments, I get a #VALUE error in the cell in Excel ("A value used in formula is of the wrong data type" ).
I've downloaded the complete sample from the URL above and get the same error when running it (after recalculating the formulas).
I've created a test 'proxy' function (in which the code can be stepped through, which calls the dll function) to ensure that values sent to the dll function are indeed of type double and that seems to be the case ...
This guy seems to have had the same problem, however no solution was posted:
http://www.ozgrid.com/forum/showthread.php?t=54245[^]
Any help / tips would be greatly appreciated!
g
excell dll newbie
|
|
|
|
|
I can tell you one thing as a tip ... DON'T CROSS POST IN FORUMS !!!!! Find the best forum, post the message ONCE !!!!
'g'
|
|
|
|
|
Sorry but I don't know which forum is best for this one ( ? )
|
|
|
|
|
this one c/c++/MFC ..
'g'
|
|
|
|
|
so, did you see the discussion following the article where people were talking about 'deployment' and the VS2008 redistributables, the location of the dll etc ?? - any differences ?
'g'
|
|
|
|
|
No I didn't see that ?
This is such a weird problem. Don't get why it would work for everyone else but not for me ...
|
|
|
|
|
gvanto wrote: Don't get why it would work for everyone else but not for me ...
ahh, but it didnt work for everyone - go back the page, read down past the initial steps - others did have issues and (may have) fixed them
'g'
|
|
|
|
|
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
|
|
|
|
|
PS: I dont have admin rights on this machine else I'd give the VS2008 redistro stuff a go, sure sounds like it could work ...
|
|
|
|
|
Im sure there are other people out there who can answer that one better than I can ...
'g'
|
|
|
|
|
Hi All,
I created a MSI with help of wise installer with merg modules option.
When i installed my application on client machine, the application is not able to get the MFCVC90.dll and MSVCR90.dll.
The wise installer is copying these files to
WinSxS\XXXXX\XXXX folder.
How can i make sure that wise copies these dll's to system32 for my application to run without problems.
Regards,
Ramchandra
Ramchandra
|
|
|
|
|
Hi ,
I am a beginner but I would like to learn.
I would like to use a new thread to read some data with an USB-module and to print it out in a CViewForm.
Now I have a total working program that can read and print when I click on the start button, but an infinit loop under the startbutton is written to read data until I click on Stop.(the data is real-time printed on the screen in a graph) This ofcourse is not possible because I stay in the loop under the startbutton. I can't click anything.
This logic problem I want to solve with strating a new thread just for collecting data from the USB-module and printing a graph on screen.
Now to use my old program is it possible to make an extra class derivaded from CWinThread and just call or postmessage the CView and CDocument members or functions ? If I could use my CView and CDocument members and functions in the InitInstance I thing I have a solution.
Maybe I am totaly wrong , I am just a beginner
Thanks a lot (sorry for my English)
|
|
|
|
|
Piction wrote: I am a beginner but I would like to learn.
Then I strongly suggest you obtain and read learning materials specifically designed for beginners rather than posting things into internet forums.
|
|
|
|
|
Howdy everyone...
Could someone help me? I'm trying to write an algorith tht returns all the possibilities of the letters in a string, that starts at the initial word, then works its way down to all comniations of 2 letters.
To say it another way... if I have "ABCDEF", the function will return "ABCDEF" first (as there is only one of these), then return 6 strings of 5 letters each ("ABCDE", "BCDEF", "ACDEF", "ABCDF", "ABDEF" and "ABCEF"), as only 6 exists, then return 15 strings of 4 letters each, then 20 of 3 each, 15 of 2 each, and stop.
C++ or C# or just an idea of how to accomplished this would be great.
Thank you so much,
Michael
== // ==
BlueCoder
|
|
|
|
|
Use a bucket for every other letter in the alphabet. Then every letter you trip over, pour it into the right bucket.
|
|
|
|
|
led mike wrote: Use a bucket for every other letter in the alphabet. Then every letter you trip over, pour it into the right bucket.
You mean like A C E G I, etc., then I lost you?
What about the 'even' letters?
Michael
== // ==
BlueCoder
|
|
|
|
|
By 'bucket' I think he means an array of integers where each entry represents one of the letters of the string. "Pooring into the right bucket" means incrementing the count of that letter's entry in the array.
That was a good hint but I think it is best that you figure it out from there. 
|
|
|
|
|
Do you recommend the boost version of a bucket or the MFC version ?
|
|
|
|
|
Thanks Rick...
Either one, if that was a question to me.
Michael
== // ==
BlueCoder
|
|
|
|
|
No, sorry. My reply was an attempt at a bad joke aimed at led mike.
|
|
|
|
|
I thought that, just after I posted.  
== // ==
BlueCoder
|
|
|
|
|
 Yes I failed in resisting the urge to have a go at this student 
|
|
|
|
|
The string I'll be doing the algorithm on will not always be "ABCDEF"; it could be any arbitrary set of letters, and any length.
It is more difficult then I thought.
Michael
== // ==
BlueCoder
|
|
|
|
|
Michael Hildebrand wrote: It is more difficult then I thought.
Indeed. Has any of your professors discussed the danger of "assumptions" during the activities of software development? If they have not perhaps you should ask them.
|
|
|
|
|
you need to look up combinations & permutations. Wikipedia, google, math.com, doesn't matter.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
