Hi Hariharan, I'm glad I was able to be of help!
I have experience with neither Reflection for the Web nor Javascript. I see on the Attachmate website that you can record and playback macros as well as modify/write them manually. Recording a macro might be a good way to get most of your script done, and then you can try to make what changes you need to that. It sounds like documentation is included in the program. If you need to access your local file system on your workstation from the script, it seems you (or your administrator) may need to do something special for your script to have the proper permission to do so. Programming with Reflection for the Web 2011: http://support.attachmate.com/techdocs/2570.html Reflection for the Web 2011 Scripting Samples: http://support.attachmate.com/techdocs/2535.html | http://download2.attachmate.com/fileinfo.asp?filename=RWeb2011macros.zip If you have the desktop (not browser) version of Reflection, I see reference to a COM interface that would probably allow you to control it from VBA if you were more comfortable with that. http://support.attachmate.com/techdocs/2271.html Index of Reflection Scripting Technical Notes: http://support.attachmate.com/techdocs/9993.html You might be able to find a forum more closely related to your task or Reflection where you can find more specialized help. Best of luck. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Monday, February 27, 2012 10:31 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Asa, That’s a pretty cool explanaion from you. And as you said I am having Macro Editor option in my terminal emulation software. It is in Java script – Reflection for the web. Do you have any idea on that? Thanks for your excellent contribution.JJJ Thanks, Hariharan Tharagan Description: COE logo_mail http://knetsites.wipro.com/sites/5446/Pages/FAO-COE.aspx _____ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, February 24, 2012 12:06 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Hariharan, Is there any special reason to do this from Excel? SendKeys is unreliable, and you have no way to verify the results using built-in VBA functionality. Usually: The best place to script would be on the server using tools installed there. The next best place would be in your terminal emulation software. Some terminal emulators have scripting capability. The next best place might a scripting language with strong general system automation capabilities, such as AutoHotKey <http://autohotkey.com/> /AutoHotkey_L <http://l.autohotkey.net/> and the related AutoIt <http://autoitscript.com/> . If Excel's features are important to your task, you could either control Excel or export data to Excel from your other script, or you could look for a way, as per your request, to perform the automation work from Excel. At your disposal besides the built-in features are external features such as various COM/ActiveX libraries that extend VBAs functionality and the Windows API. With those tools at your disposal, there is practically no limit to what you can do, but it can be time consuming and more complicated. And I don't have a ready solution for you :). A possible approach with those tools at hand would be to have your macro make it's own direct TCP/IP connection to the server and be in complete control of what is sent and received. To your list of questions: > Is it possible to interact with Mainframe without connectivity? No, if you don't have a network connection to the mainframe, there is no interaction from your workstation. If you have a script running on the mainframe, though, it can work even when you are not connected, possibly even preparing results if applicable and emailing them to you or placing them for download on that or another server. > Will Send Keys work from Excel to Mainframe? Probably, but I don't recommend using Sendkeys outside of Excel, and even then only as a last resort. You cannot guarantee your keystroke will be captured by your terminal emulation client and not Windows or another application. > What are the ways to automate my process in mainframe? My most detailed reccomendations at the moment are what I've already stated. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012 7:45 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, Could you please help on this? Am I clear in the requirement? Thanks, Hariharan Tharagan _____ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012 7:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, I am a IBM Mainframe 3270, Reflection User (Terminal Emulation Front End)….and I don’t have access for Session Manager. I just need a macro to do some process automation. ü Is it possible to interact with Mainframe without connectivity? ü Will Send Keys work from Excel to Mainframe? ü What are the ways to automate my process in mainframe? Thanks in advance. Thanks, Hariharan Tharagan -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
<<image001.jpg>>
