New to Z

New to IBM Z

Deepen your technical skills, expand your global network, and connect with mentors and other early tenure professionals on the mainframe platform.

 View Only

  • 1.  Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 02/14/23 05:15 PM

    As background, we had developed a series of automated interfaces between the AS400 and iSeries Navigator (file server) using Excel VBA and the IBM PCOMM emulator. 

     Recently,  however, following upgrades of the Microsoft Office environment (including Excel) to Windows 7 (64 bit), along with upgrade to IBM I Access Client Solutions (32 bit) emulator, we unable to use the previously developed Excel VBA scripts.

    Our ask is if there is a workaround to continue to use (and develop) VBA scripting in Excel (Windows 7 and 64 bit) with the IBM I Access Client Solutions emulator (32 bit) version 1.1.9.1?

    Any guidance is much appreciated. 

    Al Rice
    (248) 761-5238



    ------------------------------
    Albert Rice
    ------------------------------


  • 2.  RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 02/17/23 04:51 AM

    Hi Al

     

    Couple of questions

    1. Have you tried using the 64-bit Windows ACS installation instead of the 32-bit?
    2. You say you're using PCOMM emulator (5250 terminal interaction?) but also that you're accessing the File server – is what you do possible by direct access to the IFS as a filesystem? Or is your VBA code screenscraping?

     

    Need more info on what those VBA macros do, before being able to suggest how best to continue development.

     

    -Regards- 

    Ross Cruickshank

    IBM Z Developer Advocate, IBM Z Xplore

    +44-7725-706869

    ROSS@vnet.ibm.com

     

    Unless otherwise stated above:

    IBM United Kingdom Limited
    Registered in England and Wales with number 741598
    Registered office: PO Box 41, North Harbour, Portsmouth, Hants. PO6 3AU





  • 3.  RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 02/17/23 07:46 AM

    You may also want to join the IBMi community and ask there - they have an ACS subgroup 

    https://community.ibm.com/community/user/power/communities/ibmi-home



    ------------------------------
    ross cruickshank
    Winchester
    ------------------------------

    Original Message


  • 4.  RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 02/17/23 01:38 PM
    Hello Russ
    The screenshot, below, shown the current Excel/VBA to AS400 flow using Excel/VBA 32 bit with old i Access for Windows  32 bit which has worked very well. The flow below the dotted line shows Excel/VBA to AS400 flow using Excel/VBA 64 bit with new i Access Client Solutions 32 bit desired solution which is not working.  Would it be possible to have a quick Zoon call for further clarification and guidance?
    This screen shows the current (working) and desired (not working) VBA to AS400 flow


    ------------------------------
    Albert Rice
    ------------------------------

    Original Message


  • 5.  RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 02/18/23 03:27 AM

    Sure – a Zoom call would be fine – I'm kind busy all day Monday – but can do a call between 12-1pm EST – send an invitation, and I'll see you then

     

    -Regards- 

    Ross Cruickshank

    IBM Z Developer Advocate, IBM Z Xplore

    ROSS@vnet.ibm.com

     

    Unless otherwise stated above:

    IBM United Kingdom Limited
    Registered in England and Wales with number 741598
    Registered office: PO Box 41, North Harbour, Portsmouth, Hants. PO6 3AU



    Original Message


  • 6.  RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts

    Posted 12/05/23 08:37 AM


    VBA Excel 32-bit on 64-bit Windows 10 - iACS emulator using EHLLAPI32.dll works fine.
    With VBA Excel 64 bit on 64-bit Windows 11 - iACS emulator using EHLLAPI32.dll doesn't work.

    Can you please help



    ------------------------------
    Manimala Balakumar
    ------------------------------

    Original Message


Related Content