Unable to Run Excel VBA Automated Connection to AS400 using iACS

With a recent upgrade of our PCs to Windows 10 (64 bit) and using iAccess Client Solutions, 32 bit, (iACS), we lost the ability to run Excel VBA automated sessions on our AS400. Previously we were using the iAccess for Windows, 32 bit (iAW), which used PCOMM features to connect Excel VBA to the AS400.

I have prepared a slide which shows the previous and current Excel VBA to AS400 flow. We have been researching for months to find a way to enable the new configuration using iACS without any success. Note: I am unable to post a screenshot on this forum.

Fortunately, we did maintain one computer in our office with the older Excel to AS400 connectivity using iAW where we continue to run the Excel to AS400 automation, but we want to implement a solution where several other computers can execute the automation in the upgraded environment.

Could someone, please contact me and I would like to have dialogue to fully explain my issue, and provide guidance towards a solution?

Thanks in advance

1 answer

My 1st guess is that your upgrade wiped out the original file transfer processes.
You may need need to install
5733XJ1 IBM i Access Client Solutions
Windows Application Package 1.1.0.
it is available as a separate CD ( IBMiAccess_v1r1_WindowsAP_English.zip) when you downloaded your ACS Client from IBM ESS
When you unzip and run \image64a\setup.exe as an elevated user on your PC you can run a Custom or Preferred install.
Hopefully this will help get you down the road.

The features included in this package from IBM i Access for Windows are:
.NET Data Provider
ODBC
OLE DB
Secure Socket Layer and Certificate Management
Programmer's Toolkit for Headers, Libraries and Documentation
AFP Printer Driver
Required Programs including:
APIs
Active X
Security
Serviceability
Connections
NLS enablement
Conversion tables
Properties
Policies
Network Printing
Subset of commands (See Section 8.0 for a list of what is not included.)
User's Guide
Use of Application Administration to control access to function in the package