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
