"Bob Phillips" wrote in message
...
Bura,

You are correct, as you had posted to the programming group I did assume
that you were referring to the VBE.

If you mean worksheet, then you don't need a file identifier, you can call
it directly if it is installed.


And this is what doesn't work for me. If I call it directly if it is
installed it works for me. But if I send the workbook to a colleague and
they also have it installed (but perhaps in a different place), then all
references to the function become qualfied like so:

'C:\PathToWhereIKeepIt\MyAddin.xla'!MyFunction()

and it no longer works. This is a problem that I also described in a post
with a different subject line.

This has become a problem which rendered the add-in that I have been
developing for a month completely useless! I would be very happy if anyone
can help!

Bura
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bura Tino" wrote in message
news:Hbkmc.37508$0H1.3454762@attbi_s54...

"Bob Phillips" wrote in message
...
Bura,

If you have installed add-ins, set a reference to the add-in in the
VBE
(ToolsReference), and then you can use its functions as if it were
local.

--

HTH


I think you are talking about using the function in VBA. My question
pertains to using the function in the worksheet.

Bura

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bura Tino" wrote in message
news:pgdmc.36726$0H1.3179676@attbi_s54...
Hi,

If I use a function defined in a vba add-in, is that considered to
be
a
link
to another workbook? If so, if I use the spreadsheet on another
computer
with the add-in in another directory, how can I make excel look for
this
function among currently installed add-ins rather than look for the
same
xla
workbook in the same location?

Thanks.

Bura