Search code examples
excelmainframevba

Connecting to TN3270 Mainframe using VBA

I need to automate a TN3270 mainframe screen using VBA , i am not able to connect to the mainframe using VBA , any chance anyone has automated a TN3270 mainframe emulator using VBA??

Solution

  • As Bruce Martin stated, it depends on the Emulator which we are using. I am using the EXTRA! Attachmate which can be automated using Excel VBA using the Extra keyword in the createobject object. Something like: 

    set New=createObject(Extra.system)

    After connection you can use the sendkeys, getstring, putstring keywords along with the co-ordinates of the screen which is pretty fun and easy.

    I have not fully figured this out, but for starters I think it's enough.