Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
It is true that from the UI perspective a UDF appears to be part of
XL's functions. However, it is not really so. It is part of the XLA that contains it. Adapt the idea at How to use a class (object) from outside of the VBA project in which it is declared http://support.microsoft.com/default...b;en-us;555159 specifically, see how the function New_clsEmployee is accessed externally. If the rest of the stuff about classes and objects is confusing, just ignore it. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , Andibevan@notehere- hotmail.com says... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
Only a subset of built in Excel functions are methods of the
WorksheetFunction object. Var_TXT = application.Run( "AddinName.XLA!myextract", Var_Source_Fold,1,"B","\") -- Regards, Tom Ogilvy "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
Thanks All - much appreciated
"Tom Ogilvy" wrote in message ... Only a subset of built in Excel functions are methods of the WorksheetFunction object. Var_TXT = application.Run( "AddinName.XLA!myextract", Var_Source_Fold,1,"B","\") -- Regards, Tom Ogilvy "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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
All I can do is demonstrate that it works. I will use the analysis
toolpak-VBA function Dec2Bin in the immediate window as an example: ? Application.Run( "ATPVBAEN.XLA!DEC2BIN",123) 1111011 -- Regards, Tom Ogilvy "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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
Thanks Tom - I will have more of a play - as you said - I can always set a
reference as a workaround for the moment. Ta Andi "Tom Ogilvy" wrote in message ... All I can do is demonstrate that it works. I will use the analysis toolpak-VBA function Dec2Bin in the immediate window as an example: ? Application.Run( "ATPVBAEN.XLA!DEC2BIN",123) 1111011 -- Regards, Tom Ogilvy "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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use UDF from Add-in in VBA
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 |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|