Page 1 of 1

Does REXX can call VBA macro?

PostPosted: Fri May 03, 2013 8:01 am
by marshall25
hi all,

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

Re: Does REXX can call VBA macro?

PostPosted: Fri May 03, 2013 1:54 pm
by prino
When was VBA ported to z/OS?

Re: Does REXX can call VBA macro?

PostPosted: Fri May 03, 2013 2:40 pm
by marshall25
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?

Re: Does REXX can call VBA macro?

PostPosted: Fri May 03, 2013 3:22 pm
by prino
You use the wrong emulator. Using Tom Brennan's Vista tn3270 this would be possible.

Re: Does REXX can call VBA macro?

PostPosted: Fri May 03, 2013 4:10 pm
by enrico-sorichetti
my preference goes to ZOC, REXX scriptable on the PC
( available for WINDOWS and MAC OSX )

Re: Does REXX can call VBA macro?

PostPosted: Sat Dec 14, 2013 5:36 am
by Pedro
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:
/* 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.