Function in Managed COM Add-in isn't exposed to wrapper xla

N

Nancyb

Hi
I'm trying to execute the public 'OfficeAddInUserName' function I've defined in my C# COM add-in called 'OfficeAddIn'. The following function in my xla is retuning an 'Object variable or With blockvariable not set' error

Public Function GetOfficeAddInUserName() As Strin
Dim oAdd As Objec
Set oAdd = Application.COMAddIns.Item("OfficeAddIn.Connect").Objec
On Error GoTo e
GetOfficeAddInUserName = oAdd.OfficeAddInUserName(
Exit Functio
eh
GetOfficeAddInUserName = Err.Descriptio
End Functio

Other than this, the add-in is working correctly (menus appear, etc.)

Is there a step I've missed in order to make the C# function in my COM add-in available to my wrapper xla?
 

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