V6R1 replacement excel addin

 There is a replacement data transfer addin for v6r1 in excel, when installing the V6R1 Excel data transfer add-in, CWBTFCAI.DLL is used instead of CWBTFXLA.XLL previously (both located in C:\Program Files\IBM\Client Access\Shared).

Following are instructions for installing the COM-based Excel data transfer add-in.

Excel 2002/2003 Loading the COM-based Add-in

1. On the View menu, Select Toolbars -> Customize

This picture shows the menu options used to load the COM-based add-in.


2. Click the Commands tab and under Categories, click Tools .

This picture shows the options available when selecting the customize option in the previous picture.


3. Under Commands, click COM Add-Ins... and drag your selection to the Excel toolbar.

This picture shows the COM Add-in option.


4. Click COM Add-Ins on the toolbar and select Data Transfer Excel Add-in.

This picture shows the COM Add-in Data Transfer Excel Add-in.

5. If the Data Transfer Excel Add-in does not appear in the COM Add-ins list, do the following:

a) Click Add (see previous screen).
b) Browse to the folder where you installed System i Access for Windows (default path C:\Program Files\IBM\Client Access\Shared).
c) Double-click the Shared folder.
d) Double-click cwbtfcai.dll.


Excel 2002/2003 Removing COM-Based Add-In

To unload the data transfer add-in (keeps name in the list), clear the box for the Data Transfer Excel Add-in and select OK .

To remove the data transfer add-in (removed from list), select the box for the Data Transfer Excel Add-in and select Remove .

This picture shows how to remove the COM add-in Data Transfer Excel Add-in.


Excel 2007: Load COM-Based Add-in

1. Select the Quick Access toolbar in the upper left corner of the Excel session.

This picture shows the Excel 2007 Quick Access toolbar.

2. Select Excel Options.

This picture shows the Excel Options button that will show the Add-ins option.

3. Select Add-Ins.

This picture shows the Add-ins option that can be selected for the list on the left.

4. From the Manage list, select COM Add-ins and then select Go…

This picture shows the COM Add-ins option under the Manage drop down options.

5. Select Data Transfer Excel Add-in.

This picture shows the COM Add-ins Data Transfer Excel Add-in.

6. If Data Transfer Excel Add-in is not listed, do the following:

a) Select Add (see previous screen).
b) Browse to the folder where you installed System i Access for Windows.
c) Double-click the Shared folder.
d) Double-click cwbtfcai.dll.

Browsing for the data transfer add-in per item b) above:

This picture shows the Windows path to the Data Transfer Add-in if it is not in the previous list.

7. The data transfer add-in download and upload options will then be shown under the Add-ins drop down menu in Excel 2007.

Unloading the COM based Excel Add-in

To unload the data transfer add-in from Excel 2007, do the following:

1. Select the Quick Access Toolbar.
2. Select Excel Options.
3. Select Add-ins.
4. In the Manage list, select COM Add-ins and click Go.
5. Clear the checkbox associated with Data Transfer Excel Add-in.
6. Select OK.

This picture shows how to unload the COM Add-ins Data Transfer Excel Add-in.


Removing the COM-Based Excel Add-in

1. Select the Quick Access Toolbar.
2. Select Excel Options .
3. Select Add-ins .
4. In the Manage list, select COM Add-ins and select Go .
5. Highlight the checked Data Transfer Excel Add-in.
6. Select the Remove button.

This picture shows how to remove the COM Add-ins Data Transfer Excel Add-in.

Comments