Posts by amigomadhur

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • VB Code (Emulator) for Ms Excel & AS400

    Re: VB Code (Emulator) for Ms Excel & AS400


    I used the below connecting strings for Excel & Mainframe to update the information in mainframe that earlier I used to do manually.


    Dim autECLPSObj As Object
    Dim autECLConnList As Object


    Set autECLPSObj = CreateObject("PCOMM.autECLPS")
    Set autECLConnList = CreateObject("PCOMM.autECLConnList")


    autECLConnList.Refresh
    autECLPSObj.SetConnectionByHandle (autECLConnList(1).Handle)



    Is it possible to do the same thing with excel & AS400?


    If yes, then plz help me



    Madhur