View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nacho Nachev Nacho Nachev is offline
external usenet poster
 
Posts: 26
Default Using CallByName for conversion function

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