vb script/connecting to an as400 session
-
What script can I use to connect to an AS400 session from Excel? I can use Excel to input and retrieve data from an IMS session (using Attachmate for Extra) with the following code: Public Sessions As Object Public System As Object Public Sess0 As Object Sub GetInfo() Set System = CreateObject("Extra.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession Can VB script be used for the same connectivity to an AS 400 session? If so, what is the code for setting the objects? Buuldawg
-
What script can I use to connect to an AS400 session from Excel? I can use Excel to input and retrieve data from an IMS session (using Attachmate for Extra) with the following code: Public Sessions As Object Public System As Object Public Sess0 As Object Sub GetInfo() Set System = CreateObject("Extra.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession Can VB script be used for the same connectivity to an AS 400 session? If so, what is the code for setting the objects? Buuldawg
You'd do it the same way, but the catch is VBScript or Microsoft 'anything' doesn't come with objects standard that would do that. In your example, your using a 3rd party object to make the connection. For AS400, you'd have to use another 3rd party object, like Rumba from NetManage. RageInTheMachine9532