Call a add_in function in excel vba?

[libing]

the add_in is installed, and I want to call the functions from the
add_in, seems doesn't work,how?


--
libing
------------------------------------------------------------------------
libing's Profile: http://www.msusenet.com/member.php?userid=1773
View this thread: http://www.msusenet.com/t-1870496572

[Bob Phillips]

Two ways

Set a reference to the addin (Tools>Referebces)

or use application run

Application.Run "addin_name.xla!macro_name"

--
HTH

Bob Phillips

"libing" <libing.1pw44w@no-mx.msusenet.com> wrote in message
news:libing.1pw44w@no-mx.msusenet.com...
>
> the add_in is installed, and I want to call the functions from the
> add_in, seems doesn't work,how?
>
>
> --
> libing
> ------------------------------------------------------------------------
> libing's Profile: http://www.msusenet.com/member.php?userid=1773
> View this thread: http://www.msusenet.com/t-1870496572
>

[libing]

I set a reference, still doesn't work,is it a mavro?


--
libing
------------------------------------------------------------------------
libing's Profile: http://www.msusenet.com/member.php?userid=1773
View this thread: http://www.msusenet.com/t-1870496572

[Bob Phillips]

Is what a macro?

--
HTH

Bob Phillips

"libing" <libing.1pw9ov@no-mx.msusenet.com> wrote in message
news:libing.1pw9ov@no-mx.msusenet.com...
>
> I set a reference, still doesn't work,is it a mavro?
>
>
> --
> libing
> ------------------------------------------------------------------------
> libing's Profile: http://www.msusenet.com/member.php?userid=1773
> View this thread: http://www.msusenet.com/t-1870496572
>

[Dave Peterson]

Do you mean you want to user your userdefined function in a cell in the other
workbook?

If yes, then:

=myfunction(a1)

should work (myfunction is a UDF in the addin that's loaded).

libing wrote:
>
> the add_in is installed, and I want to call the functions from the
> add_in, seems doesn't work,how?
>
> --
> libing
> ------------------------------------------------------------------------
> libing's Profile: http://www.msusenet.com/member.php?userid=1773
> View this thread: http://www.msusenet.com/t-1870496572

--

Dave Peterson

[libing]

i want to use the function from the addin in my vba code,why run
"addin_name.xla!macro_name:?bob, may I have ur msn or skype, i realle
want to make it clear.


--
libing
------------------------------------------------------------------------
libing's Profile: http://www.msusenet.com/member.php?userid=1773
View this thread: http://www.msusenet.com/t-1870496572

[Bob Phillips]

You can mail me.

--
HTH

Bob Phillips

"libing" <libing.1px71l@no-mx.msusenet.com> wrote in message
news:libing.1px71l@no-mx.msusenet.com...
>
> i want to use the function from the addin in my vba code,why run
> "addin_name.xla!macro_name:?bob, may I have ur msn or skype, i realle
> want to make it clear.
>
>
> --
> libing
> ------------------------------------------------------------------------
> libing's Profile: http://www.msusenet.com/member.php?userid=1773
> View this thread: http://www.msusenet.com/t-1870496572
>

[libing]

what is your email?
my question is i want to use this function in my vba code, the addin is
in 'C:\Program files\HoadleyOptions\HoadleyOptions.xla'!, and the
function is named ...(arguments), what to call this function, thanks a
lot


--
libing
------------------------------------------------------------------------
libing's Profile: http://www.msusenet.com/member.php?userid=1773
View this thread: http://www.msusenet.com/t-1870496572