How to use UDF from Add-in in VBA
It shouldn't, as long as the target machine has the add-in installed. The
reference will move with the spreadsheet.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
Tried that and it works fine - I find the problem with setting references
like that is that it limits the portability of the spreadsheet but it may
be
that I am missing a trick.
Thanks
Andi
"Bob Phillips" wrote in message
...
Try the other suggestion Andi, set a reference and see if that works.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
In my case it was loaded but still threw the error.
"Tom Ogilvy" wrote in message
...
Do I need to specify the path and add-in name
Not if the addin is loaded.
If it isn't you would.
--
Regards,
Tom Ogilvy
"Andibevan" wrote in message
...
I have tried your solution and am getting a runtime error 1004
saying
it
can't find the add-in - Do I need to specify the path and add-in
name
or
just the add-in file name?
Ta
Andi
"Bob Phillips" wrote in
message
...
Try this
Application.Run "addin_name.xla!myextract",
Var_Source_Fold,1,"B","\"
or set a reference to your addin project and call directly.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
Hi All,
I have a UDF that is contained in an add-in I have created
myself
(MyAddin.xla)
I have been trying to utilise the UDF as follows:-
Var_TXT =
application.worksheetfunction.myextract(Var_Source _Fold,1,"B","\")
But keep getting this error "Object doesn't support this
property
or
method"
Any pointers?
Ta
Andi
|