User defined function in different workbooks/addins problem

[winxpdows]

Hi Everyone,

Could use any help on this problem I'm having.

I created an addin that puts a formula in a cell to make use of a UDF in the addin. It works fine.

But when I make changes to my addin, save it as new name, load the new addin (same as the old but with new code for other things) and then open the workbook that had the UDF working, it now changes from

=customUDFfunction(1,2,3)

to

='C:\Documents and Settings\homeuser\Application Data\Microsoft\AddIns\AddinV123.xla'!customUDFfunction(1,2,3)


the code I'm using to create the formula in the cell is

Cells(x, y).Formula = "=customUDFfunction(1,2,3)"

I've looked around and can't find anything. I'm assuming that when I create the formula in the cell it gets tagged somehow with the addin name and location. Any ideas how to just put the formula with keeping it specific to the addin that created it?

Thanks in advance for ANY ideas!

 

[dkaydkay]

Just a shot in the dark, have you tried using? Don't know if it will work, but it's worth trying!

Cells(x, y).FormulaR1C1 = "=customUDFfunction(1,2,3)"

 

[winxpdows]

Nope. That's doesn't work. Any other ideas would be greatly appreciated!

 

[ZVI]

Hi, take a look on this thread: STRANGE BEHAVIOR for User Defined Function (UDF)