Quote:
Originally Posted by manontheedge
is it possible to run a VB6 program from a VBA Excel macro? If it is, would it also be possible to pass a value to the VB6 program?
You can use the
Shell function to run an EXE, regardless of the language in which it was created. Also, I expect that you can pass data on the command line, by including it in the string passed to Shell. Your VB program would pick up the parms from
Command$.
There are other ways to communicate with your application - for example DDE, or OLE automation.
