Re: iSeries Access Excell add-in: Windows 10, Office 16 64-bit

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Thanks Paul!  That provides an incentive for those folks to move from 
IBM i Access to iACS.

On 10/3/2019 10:43 AM, Steinmetz, Paul via MIDRANGE-L wrote:
> 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.  :)