Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replace object causes an error if search text not found | Excel Programming | |||
Call secure web services from Excel 2003 | Excel Programming | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Web Services function call and data refreshing | Excel Worksheet Functions | |||
Excel Add-In for Analysis Services and embedded Excel OLE object i | Excel Programming |