Application.run

[Philosophaie]

I have an Add-In that is linked to all workbooks. I need to access a function in the Add-In. This is what I have so far:

sFunc= "'filename.xlam'!" & fn1
res = Application.Run(sFunc, arg1,arg2)

I get an error:

"Cannot run the macro "'filename.xlam'!". The macro may not be availiable in this workbook or all macros may be disabled."

I am sure that my macro security level is at its lowest and my macros should run.

 

[RoryA]

What is the value of fn1?

 

[Philosophaie]

Function fn1(a,b,c)
fn1=2*a+3*b-c
End Function

exists in Module1 in filename.xlam

Trying to access the function from sheet1 in filename1.xlsm

 

[RoryA]

In that case:

sFunc= "'filename.xlam'!fn1"

Note that fn1 is also a cell address so not a great choice as a function name.