IBM i Access Client Solutions

 View Only
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 3 days ago
    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 3 days ago

    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
    ------------------------------



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

    Posted 15 hours ago

    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
    ------------------------------