I have seen your tip "Import file data from the AS/400 to the MS Excel document" from PAROS Junot and I do appreciate it. Usually when you install CA after MS Excel it takes care of the AS/400 transfer icon to appear into Excel toolbar automatically. If not your case, instead to play with the registry, you can do just the following:
From the menu- Tools->Add-ins->Browse.
After that select the file:
(Its typical place is: C:Program FilesIbmClient AccessShared) This will have the AS/400 data transfer icon to appear in the Excel toolbar. I very much like the 'hidden' SQL statements behind it. In fact, reporting from this place is just perfect!
This was first published in April 2001