I deal with a proprietary program that uses VBA to supply macros. I use the macros to call on com servers I have written in VFP. I use objects in the proprietary program to return values to send as parameters to my servers. For example, I set cParameter1 = ds.GetValue('Vend_No'). Since I have more than one server and they each need different values, I have set up a VFP menu program that I invoke with the WSHShell run command inside a macro. (RUN Menu.exe cParameter1,cParamter2,...)

I won't know what parameters will be needed until the user makes a selection. Then I need to know the value of ds.GetValue('Whatever'). So I would like to pass a reference to the ds object to my menu program (an exe) that could be passed on to the appropriate com server. (RUN Menu.exe DS)

Does anybody know how this can be accomplished? I need to pass a VBA object reference to VFP as a command line parameter of an EXE inside a macro, or think of a different approach. Thanks.