troubleshooting Question

Need help launching AS400 recorded macros Using VBA with PCOMM "StartMacro" Function

Avatar of Al Rice
Al RiceFlag for United States of America asked on
Windows OSVBAVisual Basic Classic
9 Comments1 Solution37 ViewsLast Modified:
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

Thanks
Al

ASKER CERTIFIED SOLUTION
Al Rice
Owner

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros