Does REXX can call VBA macro?



IBM's Command List programming language & Restructured Extended Executor

Does REXX can call VBA macro?

Postby 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?
marshall25
 
Posts: 26
Joined: Mon Jun 20, 2011 9:14 am
Has thanked: 0 time
Been thanked: 0 time

Re: Does REXX can call VBA macro?

Postby prino » Fri May 03, 2013 1:54 pm

When was VBA ported to z/OS?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Does REXX can call VBA macro?

Postby 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?
marshall25
 
Posts: 26
Joined: Mon Jun 20, 2011 9:14 am
Has thanked: 0 time
Been thanked: 0 time

Re: Does REXX can call VBA macro?

Postby prino » Fri May 03, 2013 3:22 pm

You use the wrong emulator. Using Tom Brennan's Vista tn3270 this would be possible.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: Does REXX can call VBA macro?

Postby 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 )
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Does REXX can call VBA macro?

Postby 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:
/* 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.
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times


Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post