VB Code (Emulator) for Ms Excel & AS400

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.

  • 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

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


    I think what you are asking about is directly related to communication with the AS400. Although someone here may have knowledge of that, it is somewhat beyond the scope of this forum. You would be better off looking at: http://publib.boulder.ibm.com/…ks/html/host_access08.htm which has information directly related to this kind of communiction problem.

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


    You need a workstation profile file (.WS) for the AS400 (or, start it manually). Once the terminal session is running, you can use PCOMMS to link to it and use the PCOMM commands as you have described.

    Suggest, perhaps, that you start the session manually and then

    Code
    autECLPSObj.SetConnectionByName("A")

    , but substitute "A" with whatever is the session letter of the session you started. Then you can test the PCOMMs objects.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!