Hi Nacho,
If you check the Object Browser you'll discover that CDbl is not a
property or method of a class, so you can't run it using CallByName. I'm not
clear why you would want to do so anyway, since CDbl is a global function
that can be used directly from anywhere in a VBA program.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"Nacho Nachev" wrote in message
...
Hello,
This is something that I should have known in the VB basics, but I didn't
and also it's not very Excel specific, but beacuse I am doing it in the
Excel context I guess it's relevant here.
I have the following call:
SomeFunction = CallByName(VBA, "CDbl", VbMethod, inputValue)
The problem is that I don't know the object in which the CDbl is defined.
Using VBA returns compiler error. I need to use this because "CDbl" will
be
parameterized.
Thanks for you time,
Nacho