Hello,

Is there a way to pass variant parameters from VBA to a C# COM object?
Specifically, I'd like a class to have an indexer property to store different
types from VBA - numbers, strings and dates. In C# I should be able to detect
what actual type is passed. So, the type should be variant. Here's how I
declare the property:

public object this[string name]
{
    get
    {
        if (_propertiesTable.ContainsKey(name))
            return _propertiesTable[name];
        else
            return null;
    }
    set
    {
        if (_propertiesTable.ContainsKey(name))
            _propertiesTable.Remove(name);
        _propertiesTable.Add(name, value);
    }
}

That is, is is declared as type "object". However, VBA expects the parameter
of the property to be an object. E.g. the following produces a run-time error:

myServer.Item("test") = 5

In the same way, the following function expects the second parameter in VBA
to be a reference to an object, not variant:

public void SetProperty(string name, object value)

I tried to use the MarshalAs attribute, but had no success.