Limited .xlam portability due to UDF links

[Boswell]

Hello,

I have a .xlam file that contains UDFs. When a spreadsheet model built using the .xlam is passed to a different computer (that also has the .xlam installed) the UDFs attempt to link to the path of the .xlam on the previous computer. This can be fixed by editing links and referencing the .xlam on the current computer.

How can I avoid having to edit links when sharing a file created using UDFs from a .xlam? I've considered moving my code to a .dll addin using VSTO, however I read that UDFs should not be created with managed code.

Any suggestions will be greatly appreciated.

Thanks

 

[Andrew Poulsom]

Have a look at this:

http://www.jkp-ads.com/Articles/FixLinks2UDF.asp

 

[Boswell]

Thanks! That is what I was looking for.