PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?c3dvcmRzbWFu?=
Guest
Posts: n/a
 
      13th Jun 2007
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Macro w/ AppActivate = Run-time error '5': Invalid procedure call or argument Per Moeller-Olsen Microsoft Excel Programming 4 27th Apr 2009 10:38 PM
Excel Macro error in Add method of object _VBcomponents Cap Kirk Microsoft Excel Programming 5 22nd Jan 2009 10:50 PM
Excel 2007 Beta 2 - Macro Run-time error '424' Object required =?Utf-8?B?amNtMjE=?= Microsoft Excel Programming 0 16th Jun 2006 07:17 PM
Object reference not set to an instance of an object error during netapi32 call Kurt Van Campenhout Microsoft VB .NET 5 19th Nov 2003 11:46 PM
Object reference not set to an instance of an object error during netapi32 call Kurt Van Campenhout Microsoft VB .NET 1 18th Nov 2003 09:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:35 AM.