How to Slow Down a AS400 .mac Macro when Call Using "StartMacro" Function Within VBA Code

I have asked my IT department to search for any patches for the PC5250 emulator: iSeries Access for Windows which may fix my issues with long AS400 macros which fail during execution.  No response yet.

Has anyone else had this same experience, and resolved it with alternative solution?

Any help is appreciated.

Thanks
Al

VBA Macro's (vbscript) are NOT AS400 macros.  Completely different interpreters

Hi,
I think you are after something like

Dim autECLOIAObj as Object

 

Set autECLOIAObj = CreateObject("PCOMM.autECLOIA")

autECLOIAObj.SetConnectionByName("A")

 
'' wait for system available with 15 second time out
if (autECLOIAObj.WaitForInputReady(15000)) then

msgbox "Ready for input"

else

msgbox "Timeout Occurred"

end if

Select allOpen in new window

a full list of commands can be found here
https://www.ibm.com/docs/en/personal-communications/5.9?topic=library-host-access-class-automation-objects
with examples

What version of Windows?
What version of IBM i Access for Windows or PCOMM?
Do you have the most recent service pack available for your version of IBM iAW or PCOMM installed?

This is my old request, which brought me to this site.  My IT resource has been out on medical and has recently returned and is investigating the Service Pack question, which has some licensing implications.   We were finally able to get the VBA code to launch and run the pre-recorded Macro(.mac), only by splitting the Macro in multiple steps and then have the VBA code to "call" the various phases (steps) of the Macro in separate "calls".  It was very painful but we finally got it to run.  For some "unknown" reason, perhaps the AS400 manages "wait times" differently when the Macro is launched from the PCOMM menu versus being "called" from within VBA.  Not sure.

I came to this expensive site with one discrete question and cancelled my subscription when I could not find someone who had my same experience.  I renewed my subscription today because I was notified there were some response to my question.  I have a reminder to cancel again in 20 days so that I am not charged for standing by.  Not sure it the value proposition is the right model for this site.  Perhaps others disagree.  Thank to all who weighed in on my question.

Hi,
No problems with me.
I don't come here to gain points anymore - I was page editor for about 10 years.
I still get all the notifications - if I see a something  that interests me I try and help.
its great you have a resolution - post it - it could be helpful to others - it am a passionate about sharing solutions - especially on the more obscure areas such a client access macros.
Dave