RE: IBM Client Access Express Plug-in... -- SYSTEM21

Scott,

See what you can do with a User Exit Program on the Line Description. I seem
to recall that you can intercept requests on that line.
Sorry, you will have to hunt down what the codes and parameters are.

Regards

Michael Berman

(m) 0419 324 558

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]On
Behalf Of Grinstead, Scott
Sent: Saturday, 24 May 2003 1:09 AM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] IBM Client Access Express Plug-in...

It needs to be added to the TOOLS menu in excel by using the "Add-Ins..."
option from the tools menu.  Browse to the folder C:\Program
Files\IBM\Client Access\Shared\ and choose the cwbtfxla.xll (this file path
is the default).  If the option is not in the folder re-run the selective
"EZ-Setup" option to install the data transfer options.


NOTE:  V5R1 Client access express includes both a file download (from the
AS/400) and a file upload (to the AS/400).  We have yet to figure out a way
to prevent users from sending a file to the AS/400.


Scott Grinstead
Sr. Programmer/Analyst
Rocky Shoes & Boots

 -----Original Message-----
From:   Jeff Klipa [mailto:jklipa@xxxxxxxxxxx]
Sent:   Friday, May 23, 2003 11:00 AM
To:     system21@xxxxxxxxxxxx
Subject:        [SYSTEM21]   IBM Client Access Express Plug-in...

We're deploying some new PCs with WinXP Pro and Office XP...
We're using Client Access Express at V5R1M0...
We've noticed that the plug-in to Excel does not appear with the above
configuration...

There is an option to Import External Data, but I have to set the users JOBD

with the correct library list or something because it connects to the AS/400

just fine but only displays some handful of system library names...  I'm not

sure but it's too kludge for our users to adapt to...

This means the download/upload will have to be done in two steps...  Do the
normal CA upload or download from/to the pc file then for a download open
the .txt file in Excel and define the columns etc. to get it into the
spreadsheet...

Has anyone else experienced this problem and has anyone found any plug-ins
for the above config to get that file transfer button back on the tool bar
in Excel 2002(Office XP)...?

I know this is slightly off-topic so I hope you will excuse the
infraction...

Thanks.

----Original Message Follows----
From: Steve Dodkins <Steve.Dodkins@xxxxxxxxxxxxxxx>

Just a thought, but if you load IBM client access after loading excel the
extra icon appears within excel for the download options is this the same?

Regards

Steve Dodkins

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.