Joe,
You no longer need the add-ins with ACS.
In ACS
Open a blank Excel (20160 in our case)
Transfer from IBM i
Change the Output device from file to Active Excel Spreadsheet.
Works great.
Also, ODBC driver no longer needed for this to work.
Paul
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Joe Pluta
Sent: Thursday, October 03, 2019 11:38 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: iSeries Access Excell add-in: Windows 10, Office 16 64-bit
Although I use iACS (Access Client Solutions) for my normal 5250 access, I still use the Excel upload capability from good old IBM i Access for Windows. It has worked wonderfully right up until now.
Recently we switched the office to Windows 10 and everything seemed to be working fine. I was able to add the add-ins, and also, with a little prodding, make a shortcut to Office with the /X switch that made the add-in work and play nicely with Office. I thought I was good.
Unfortunately, it seems that this only works for the 32-bit version of Office (which I have), and not the 64-bit (which folks in accounting have). Does anybody know if:
1. There's a way to get the shipped CWBTFCAI.DLL to work with 64-bit Office 2. There's a 64-bit version of that DLL 3. There's an alternate add-in that might work the same way
I tried to sell the "nobody REALLY needs 64-bit Excel" idea, but that didn't fly, especially in accounting. :)
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
