Issues Using Monarch COM Automation with IBM Access Client Solutions and AS400

Al_22614
Al_22614 Altair Community Member
edited June 2023 in Community Q&A

Hello All:

I am a longtime Monarch user, and over the past 3 years have built much automation involving use of Monarch, Excel VBA and AS400.  Much of the automation involved using Monarch COM connecting to the AS400 and i Series Navigator using Excel VBA scripting to connect to the AS400 navigate screen forms, loading data to forms and extracting data from the AS400 file server.   Recently, IT has updated the Windows, Excel and the IBM emulator platform (IBM Access Client Solutions) to the latest versions of each, and now none of my VBA scripting works.

Does anyone here have experience using Monarch COM and VBA with IBM Access Client Solutions (ACS), either 32 bit of 64 bit versions?  I am cognizant that ACS is Java based, but I am not a Java expert.  If anyone is having success using ACS with Excel VBA and Monarch COM, or can direct me to someone with similat platform as mine, I would be eternally grateful to have follow on dialouge  I have researched this issue for many months, without success.

Thanks in advance for any guidance.

Al

Answers

  • Lloyd Lualhati
    Lloyd Lualhati
    Altair Employee
    edited June 2023

    Hello,

    I believe this has something to do with your Monarch license. Please open a ticket to support and they should be able to help.