[Invoke VBA] How to read the retrieved COM__Object in UiPath? VBA Function returns custom type

Help
4

I thought of many ways to create a “hack” but I strongly want to avoid a hack.
I could also create a CSV or as you said a string representation or simply make all of them a String and put them in a String array but that’s extremely ugly and I’m 100% sure there is a way without a hack.

Actually I found a solution to read the members of my own class: C#: Using reflection with COM objects | Mehroz's Experiments

//get the value of comObject.PropertyName
object propertyValue = comObject.GetType().InvokeMember("PropertyName", System.Reflection.BindingFlags.GetProperty, null, comObject, null);

//set the value of comObject.PropertyName
comObject.GetType().InvokeMember("PropertyName", System.Reflection.BindingFlags.SetProperty, null, comObject, new object[] { propertyValue });

The only problem I have now is to be able to read it as a collection.
EDIT: I gave up on the collection.