View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Using a function from a vba add-in: is that considered an external link

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.

--

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