Hi,
I want to pass an argument Celldescr from mdl programme to VBA code.
i know how to call a VBA macro from mdl,
mdlInput_sendKeyin("vba run myvba",0,1,NULL);
But i don't know how to pass a Celldescr from mdl to VBA and how to get it from VBA?
Please,Can anyone give me a solution?
Thanks,
Jeyan
Jeyan: I want to pass an argument from MDL programme to VBA code. I know how to call a VBA macro from MDL: mdlInput_sendKeyin ("vba run myvba", 0, 1, NULL);
I want to pass an argument from MDL programme to VBA code. I know how to call a VBA macro from MDL:
mdlInput_sendKeyin ("vba run myvba", 0, 1, NULL);
There are several ways, some more elegant than others:
Regards, Jon Summers LA Solutions
Just one note about my "research" around this issue :-)
To have mdlVBA_executeLine usable, there should be at least one VBA project loaded.
By default is loaded Default project, but its presence is not guaranteed.
HTH