Is it possible for VBA in Excel to assign to a member variable of a
class in a C# COM AddIn? In C# I have:
namespace mySpace
{
[ClassInterface(ClassInterfaceType.AutoDual), ComVisible(true)]
public class myClass : IDTExtensibility
{
public double myDouble;
public myClass(){}
}
}

in VBA I have:
Dim aClass As mySpace.myClass
Sub Testing()
Set aClass = New mySpace.myClass
aClass.myDouble <--------------------This errors 'unkown member'
End Sub

Is there a way to access member variables in my class or must I write
accessor functions?

Did you get solution to ur questions?
I have a same problem, i need to inform my .Net app about the change a
chagne in excel file. Can VBA macro communicate with .Net app through
interprocess communication or llike send events to my application? Any
help or code snippets would be of great help

venky

Matthew Wieder wrote:
Is it possible for VBA in Excel to assign to a member variable of a
class in a C# COM AddIn? In C# I have:
namespace mySpace
{
[ClassInterface(ClassInterfaceType.AutoDual), ComVisible(true)]
public class myClass : IDTExtensibility
{
public double myDouble;
public myClass(){}
}
}

in VBA I have:
Dim aClass As mySpace.myClass
Sub Testing()
Set aClass = New mySpace.myClass
aClass.myDouble <--------------------This errors 'unkown member'
End Sub

Is there a way to access member variables in my class or must I write
accessor functions?