App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  VBA macro for AC400

    Posted Mon May 19, 2025 10:23 AM
    Hello,
    If this topic does not belongs to this group - sorry for that. I'm new here. 
    I want to input some data from the Excel file (32bit) using VBA into AC400 IBM client (version 5250 in 64 bit).
     
    Till now, in our firm we were using client 3270 (32 bit) and library Host Access Class Library (PCOMM) and everything was working fine.
    But we need to switch to new version of the client and we have some issues with that. 
     
    Some of the methods are not working properly and I'm trying to find some workaround. For example method 'GetText' -it retrieves some weird text instead of text in indicated field from the client, and method 'WaitForAppAvailable' is waiting forever, because the property 'Ready' for 'autECLOIA' is always set to 'FALSE' no matter what.
    Other methods (like SendKeys, SetText) are working.
     
    Thanks for all suggestions in advance


    ------------------------------
    Michał Spychała
    ------------------------------


  • 2.  RE: VBA macro for AC400

    Posted Tue May 20, 2025 08:13 AM

    The weird characters you mentioned, are you sure this is not just a CCSID (Coded Character Set ID) problem?



    ------------------------------
    Francois Brandelik
    ------------------------------

    Original Message


Related Content