I am new to connecting to the AS400 using Windows Client Access emulator. I have written VBA scripts in Excel to load data to the AS400. Could someone suggest how to launch a AS400 macro using VBA. I have tried "STRPCO" and "STRPCCMMD", and "StartMacro" without success. I can select recorded macros from the CL menu, but I want to program the same in VBA. Any guidance would be appreciated.
I did make some progress with the "StartMacro" function, but halfway through running the macro, it aborted and I got the following Error:
Runtime Error '440'
Emulator interface (ehllapi) error. reason 9
Any help would be much appreciated