PC Review


Reply
Thread Tools Rate Thread

DLL that takes and returns ranges does not always work

 
 
=?Utf-8?B?QmlnQnJvdGhlcg==?=
Guest
Posts: n/a
 
      20th Oct 2007
Hi,

I have a DLL written in C++ that takes ranges as arguments and returns also
a range. For some reason it does not always return numerical values. In
other words, I need to click "Shift+Ctrl+Enter" repeatedly to get it to work.
When it does not return numerical values, it fills in the cells with
"#VALUE!". Any idea on how to fix this?

The DLL has an embedded optimization process that runs longer for certain
input values. Could this be a problem? Do I need to slow Excel down somehow
to make it wait for the DLL to finish the optimization. If so, any idea on
how to do this?

Thanks tons!

PS: Here is my linker line in Excel:
Declare Function baBDTTree Lib "C:\...\BDTdll.dll" (a() As Double, b() As
Double, c() As Double, n As Integer, deltaT As Double) As Double

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
INDEX formula returns #REF! error for ranges larger than two cells hmm Microsoft Excel Worksheet Functions 3 18th Feb 2008 01:58 PM
Generic class which takes command string and returns datareader? =?Utf-8?B?UGV0ZXI=?= Microsoft VB .NET 7 28th Aug 2007 11:02 PM
How to work out annualized % returns =?Utf-8?B?S2V2aW4=?= Microsoft Excel Misc 3 10th Oct 2006 11:58 PM
Named Ranges created by search returns penc Microsoft Excel Worksheet Functions 6 19th Jul 2003 09:37 AM
Named Ranges set by search returns? penc Microsoft Excel Worksheet Functions 0 18th Jul 2003 07:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:38 PM.