Can't call Excel Services UDF from macro, object not found error

S

swordsman

Hello,

I am attempting to call an Excel Services UDF explicitly from a macro
(invoked by a button click).

I registered the Excel Services UDF as a COM add-in as outlined in the
article (http://msdn2.microsoft.com/en-us/library/bb267252.aspx), and can
invoke the UDFs using cell references (i.e. =HelloWorld())

However, when I try to invoke a UDF in a macro, it failed with object not
found. I tried prefixing the namespace, etc, no luck
XlUnlimitedUDFs.HelloWorlds()
XlUnlimitedUDFs.XlUnlimitedUDFs.HelloWorld()

Thanks a million,
Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top