troubleshooting Question
Need help launching AS400 recorded macros Using VBA with PCOMM "StartMacro" Function
Al Rice
asked on
asked on
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'
Any help would be much appreciated
Thanks
Al
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
Thanks
Al
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.