REGISTER or login:
I am in EXCEL 2013 and I want to extract the data when I have excel open with the ADD IN or COM
I finally got a response from IBM. see below:
Here is the information on only
able to use the Data Transfer Addin only one time in MS Excel 2013. As stated
we have not tested IBM Access for Windows with Excel 2013 so technically it is
not supported, but here is what we found.
One important new feature of Excel 2013 is that it no longer supports MDI (Multiple
Document Interface) and it now uses the SDI (Single Document Interface)
paradigm, just following a trend that other Office applications, like Word,
started a few years ago. With this new behavior, every Excel document opens a
window handled by the same Excel process.
With Excel 2013, the default you have is to create a new window within the
existing Excel process. In order to force the creation of a separate instance
of the Excel process, you have these options:
1. From the command prompt, run EXCEL /X and you will open Excel window as a
new instance. The /X command switch forces the creation of a new instance.
2. Right click on the Excel Tab in Windows taskbar keeping the ALT key pressed.
And without releasing the ALT key, click on “Microsoft Excel 2013” option from
the context menu. Excel will ask you if you require opening Excel as a new
instance. You might press YES.
Please note you cannot use this technique to open an existing document – you
have to create the new Excel process first, and then open the existing workbook
3. The other option would be to remove and add the Data Transfer addin every
time you need to use in Excel 2013.