IBM Mainframe Forum

by **marshall25** » Fri May 03, 2013 8:01 am

hi all,

is there anyone know if REXX can call VBA macro in ISPF? i mean if REXX can trigger VBA macro?

by **prino** » Fri May 03, 2013 1:54 pm

When was VBA ported to z/OS?

by **marshall25** » Fri May 03, 2013 2:40 pm

hi prino,

i used terminal emulator like Pcomm to connect TSO, we know it can record your typin and save it as macro, next time you can run this macro to repeat your typin, my question is if we can use REXX to trigger this macro?

by **prino** » Fri May 03, 2013 3:22 pm

You use the wrong emulator. Using Tom Brennan's Vista tn3270 this would be possible.

by **enrico-sorichetti** » Fri May 03, 2013 4:10 pm

my preference goes to ZOC, REXX scriptable on the PC
( available for WINDOWS and MAC OSX )

by **Pedro** » Sat Dec 14, 2013 5:36 am

I apologize for the lateness of my reply...

ISPF provides a workstation agent (WSA). You have to download it, install it, start it. It is a workstation program that ISPF can communicate with.

Your rexx program can run on TSO ISPF and can issue a workstation command like this:

Select all

/* rexx */
ip = 'xx.xx.144.175'
title = 'PEDRO'
Address ISPEXEC

/* connect to the workstation */
"wscon ip(ip) title(title) codepage(1140) " ||,
"charset(0695) noguidsp panel(onerror)"
Say 'rc='rc

/* launch the browser */
"select wscmd(C:\test\index.html) modeless min invis"
Say 'rc='rc

I am not familiar with VBA, but guess that if it has a line command interface, that you can indeed launch it from ISPF.

IBM Mainframe Forum

Does REXX can call VBA macro?

Does REXX can call VBA macro?

Re: Does REXX can call VBA macro?

Re: Does REXX can call VBA macro?

Re: Does REXX can call VBA macro?

Re: Does REXX can call VBA macro?

Re: Does REXX can call VBA macro?