Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need macro to link excel with mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Sun May 09, 2010 8:54 pm    Post subject: Need macro to link excel with mainframe
Reply with quote

Hi,

My requirement is to add new 139 error codes and its description.

Error codes is present in column A of the excel sheet.
Error description is present in column B of the excel sheet.

I have to copy the error code and its description from excel and paste it in
mainframe online CICS screen and hitting the ADD action code (A).

My senior did one macro (or Vb script?). This macro will automatically switch to excel ,copy the error code from excel and again swith to mainframe screen
and add it. It is processing row by row from the excel sheet and processing continues until all codes present in excel are added.

I thought to ask him. But unfortunately he is unable to contact.

Does anybody have idea about what he did?

Thanks for sharing your thoughts,
R KARTHIK
Back to top
View user's profile Send private message

Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1250
Location: Israel

PostPosted: Sun May 09, 2010 9:16 pm    Post subject: Reply to: Need macro to link excel with mainframe
Reply with quote

The way you describe it, it is most certainly a vb script executed in the mainframe emulation program.

If you use IBM Personal Communications emulator, then you can try to record a macro that does the Add and Paste thing.
(check that it is recorded as a VBScript file, not a macro file).
Then you will have to manually edit this script to add the Copy from Excel.
And then add (manually again) the loop part.

For other emulators, there is certainly a similar option, but in all cases I'm afraid you will have to do some vb scripting.

It doesn't look too easy, but should be possible.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1250
Location: Israel

PostPosted: Sun May 09, 2010 9:18 pm    Post subject:
Reply with quote

Of course, the easiest way is:
1. Save the Excel document as a CSV file.
2. Transfer the file to the Mainframe.
Back to top
View user's profile Send private message
karthikr44

Active User


Joined: 25 Aug 2007
Posts: 235
Location: Chennai

PostPosted: Sun May 09, 2010 10:40 pm    Post subject: Reply to: Need macro to link excel with mainframe
Reply with quote

Hi Marso,

Thanks for your reply. I also thought it is a VB script.

Quote:

Of course, the easiest way is:
1. Save the Excel document as a CSV file.
2. Transfer the file to the Mainframe.


Here i dont want to copy the contents from excel file to PS or PDS file.
I want to copy the error code row by row from excel and paste it in CICS online screen. Here the screen will allow to add one error code at a time and no option to add all error codes at one shot.

So if i want to manually add 139 error codes, i have to press ALT+TAB between excel and mainframe 139 times.

Thanks
R KARTHIK
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1250
Location: Israel

PostPosted: Sun May 09, 2010 11:49 pm    Post subject:
Reply with quote

First of all, tell us about your emulation program (name and version).
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon May 10, 2010 1:15 am    Post subject:
Reply with quote

Hello,

If you have users spread geographically, how will each user have access to all of the codes/descriptions if this is implemented on the desktop?

As this is an online cics application, the error codes and descriptions should be available to the application , not the terminal emulator.

What happens when some group of users changes emulators (and yes it does happen with some regularity).

Why introduce code that is non-standard for the application when it is so trivial to implement correctly. . .

To me, this sounds like someone has a cute trick and wants to use it rather than meeting any real business requirement.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. ISREDIT Macro is not returning back t... nico_neoz CLIST & REXX 21 Sat Nov 18, 2017 7:40 pm
No new posts Mainframe Blocks to Tracks conversion upendrasri JCL & VSAM 1 Sat Nov 18, 2017 10:52 am
No new posts NDM 300 files from mainframe to linux shreya19 All Other Mainframe Topics 2 Thu Oct 26, 2017 11:40 am
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us