Excel 07 + iSeries Excel Add-In crashing

[Ron McIntyre]

I am test bedding Vista and Office '07 with our legacy programs.

As our main databases reside on an AS/400, we extract considerable data for
reporting by way of the iSeries Access for Windows Excel Add-in. This has
always worked fine in previous versions of Office.


However, in Excel '07, when attempting to run the connection, the program
crashes.
The add-in works properly up until the point when the data is to be
virtually transferred to the Excel sheet. (You can see the libraries and
files, make field selections, and play with the data options etc.).


Running the transfer outside of Excel works fine.


Office diagnostics can provide no info or help.


Program info as follows:
Microsoft Office Excel 2007 (12.0.4518.1014) MSO (12.0.4518.1014)
IBM iSeries Access for Windows V5R4M0 SI25949


Error Event as follows:
Event 1000 - Application Error: Faulting application EXCEL.EXE, version
12.0.4518.1014, time stamp 0x45428263, faulting module EXCEL.EXE, version
12.0.4518.1014, time stamp 0x45428263, exception code 0xc0000005, fault
offset 0x00a14457, process id 0x107c, application start time
0x01c7625a54ed8fd2.


Anyone with any ideas?


Thanks in advance for your time.


Ron McIntyre
Montreal, Canada

(Cross posted from microsoft.public.office.misc )

 

[Harlan Grove]

I am test bedding Vista and Office '07 with our legacy programs. ....
Running the transfer outside of Excel works fine. ....
Anyone with any ideas?

....

Either (1) run all transfers outside Excel/Office, possibly calling
canned WSH scripts from Excel macros to generate files the macro could
import after the WSH script ends, or (2) stick with your current
version of Office until there's an upgrade for iSeries that's
certified to work with Excel 2007.

Finally, this isn't an Excel question, it's an iSeries question. When
two different products work fine separately but don't work together,
it's the product with the SMALLER market share that needs to fix its
product. MSFT isn't going to change anything in Excel 2007 to make it
work with an add-in designed to connect to servers running IBM
operating systems.