Use XLL UDFs in an other XLL add-in

Add-in Express™ Support Service
That's what is more important than anything else

Use XLL UDFs in an other XLL add-in
Use XLL UDFs in an other XLL add-in, how to set a reference 
Henri Pellemans


Guest


Hi at ADX,

I read https://www.add-in-express.com/forum/read.php?FID=5&TID=14368 forum topic, but I still don?Â?Ð?ét know how to use UDFs from one XLL add-in in another XLL add-in. I still use VS2010 with the most recent ADX. Let me give you an example.

XLL Add-in Tax has a UDF = incomeTax.

XLL Add-in Finace has a UDF = netIncome = income ?Â?Ð?ã incomeTax

I want to reuse the UDF incomeTax from the Tax XLL Module in the Finance XLL Module.

In Finance I set a reference to Tax.dll (did not know whether to use the DLL file from the obj folder or the bin folder). In the XLLModule of Finance I imported Tax.XLLModule1.

This seemed to work for a few minutes, but after I imported the XLLModule from third XLL Add-in I did not see the UDFs anymore. I deleted the projects and started again with the Tax add-in and the Finance add-in, but I still was not able the use the UDFs from the Tax add-in. Which is peculiar, because before it was working well.

Any idea how to fixed this? To avoid misunderstanding, I don?Â?Ð?ét want to create a separate DLL file in VB.NET, I just want to reuse the DLL in which the ADX UDFs are stored.

Could there be a problem if a XLL add-in has AdditionalXLLModules or when the XLLModules are renamed (e.g. called incomeTaxFunctions or corporateTaxFunctions).

Best regards,

Henri
Posted 09 May, 2019 02:30:50 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Hello Henri,

To use the same code in different add-ins, you need to create a class library (DLL) containing that code, and reference that DLL from the add-ins.

Henri Pellemans writes:
In the XLLModule of Finance I imported Tax.XLLModule1.


How do you do this?


Andrei Smolin
Add-in Express Team Leader
Posted 09 May, 2019 08:23:19 Top