Original Message:
Sent: Sat February 18, 2023 03:26 AM
From: ross cruickshank
Subject: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts
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
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:
Sent: 2/17/2023 1:38:00 PM
From: Albert Rice
Subject: RE: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts
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?
------------------------------
Albert Rice
Original Message:
Sent: Fri February 17, 2023 04:50 AM
From: ross cruickshank
Subject: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts
Hi Al
Couple of questions
- Have you tried using the 64-bit Windows ACS installation instead of the 32-bit?
- 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
Original Message:
Sent: 2/14/2023 4:22:00 PM
From: Albert Rice
Subject: Need Help Converting Excel VBA Automated Scripts to PCOMM/HOD Scripts
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.
------------------------------
Albert Rice
------------------------------