Passing VBA variable to iLogic

[Anonymous]

I'm trying to pass a string variable from a VBA function (using VBA editor, not VB.net) to iLogic. I'm stumped. I thought that maybe using the syntax: stringName = InventorVB.RunMacro(....) would work, but it's not passing the variable. Anyone have an idea? Is it possible?

[MechMachineMan]

Hi, 

Using the programming documentation it appears that you can use a ByRef variable to get a return value from the macro when you use the execute method.

http://help.autodesk.com/view/INVNTOR/2018/ENU/?guid=GUID-EDE3F358-CAEB-453A-AE3C-589C59732D3F

[Anonymous]

Hmmm, I was hoping that would be it, but I feel like that object is a vba object, not an iLogic object. I've got the VBA code returning a string, it's just that iLogic is bringing it back over.

So, I send some arguments to VBA, it process them and creates a string that I want to send BACK to iLogic.

[MechMachineMan]

Sure. But at the end of the day, all of the calls are still utilizing the API (regardless of what programming language you are using), so the link I posted is still valid.

Sure, there might be a snippet in iLogic that does it as well, but good luck finding documentation on it to point you in the right direction!