IBM i Access Client Solutions

IBM i Access Client Solutions

Connect, learn, share, and engage with IBM Power.

 View Only
Back to discussions
Expand all | Collapse all

Need Help Converting Excel VBA Automated Scripts from i Access for Windows to Work with i Access Client Solutions

  • 1.  Need Help Converting Excel VBA Automated Scripts from i Access for Windows to Work with i Access Client Solutions

    Posted Fri June 28, 2024 02:29 PM
    Hello Manimala:

    Did you find a solution for this issue?  I gave up and decided to use Python, as I could not find much assistance for IBM Hascript.

    Please advise.
    Al Rice


  • 2.  RE: Need Help Converting Excel VBA Automated Scripts from i Access for Windows to Work with i Access Client Solutions

    Posted Fri June 28, 2024 03:09 PM

    Hi,

    you can download ODBC provider for Windows to use with VBA. name "IBM i Access Client Solutions - Win AP ". From IBM ESS.This package contains same option which are in i Access for Windows

    regards



    ------------------------------
    Virgile VATIN
    ------------------------------

    Original Message


  • 3.  RE: Need Help Converting Excel VBA Automated Scripts from i Access for Windows to Work with i Access Client Solutions

    Posted Mon July 01, 2024 05:09 PM

    You will need the EHLLAPI package as well. Note that the API is currently only available for 32 bit office although Tim Rowe from IBM is working on the 64 bit API as we speak. It was supposed to be delivered by June, but this has lapsed. Tim is waiting on "IBM" as I understand it. Somewhat ironic.

    See EHLLAPI With the Access Client Solutions Emulator (ibm.com)



    ------------------------------
    Greg Craill
    ------------------------------

    Original Message