Hi I found these threads here:
- How to read the -COM object returned from invoke VBA activity as a Collection?
- excel - How to return object to UiPath in VBA? - Stack Overflow
- How to convert output value of invokeVBA into a collection?
The first one didn’t get a single answer that’s why I’m here. I found out that you can not retrieve a Collection via Invoke VBA as stated in this documentation: https://support.microsoft.com/de-ch/help/323737/bug-error-message-when-you-try-to-pass-a-collection-object-from-visual
I now try to do it with my own class in VBA. My class consists of (String, String, Bool) and I want to return this to the VBA function and then use it in UIPath. I tried to treat it as an object and then read its properties like this: vb.net - Loop through values of properties of an object? - Stack Overflow
but it also doesn’t work.
How can I read the retrieved COM Object so I can use its values/access members of my VBA class in UIPath?
Thanks.