RE: From PC to AS400 data transfer

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
In Excel, Tools, Add-ins, Browse C:\Program Files\IBM\Client Access\Shared
for the cwbtfxla.xll.


Regards,
Jon A. Erickson
Sr. Programmer Analyst
800.COM Inc.
1516 NW Thurman St
Portland, OR  97209-2517

Direct: 503.944.3613
Fax: 503.943.9313
Web: http://www.800.com


-----Original Message-----
From: Sannan Solberg [mailto:SSolberg@Washcorp.com]
Sent: Tuesday, August 28, 2001 7:16 AM
To: 'midrange-l@midrange.com'
Subject: RE: From PC to AS400 data transfer


I would like more info on this add-in if someone finds it.  I don't see it
in the Excel Add-in's but always wished there was one.  You can setup the
data transfers via C/A (somewhat assuming the file names stay static) and
just put shortcut icons to each transfer on their desktop.  All the user
would have to do is poke the icon and the Start Transfer button!

-----Original Message-----
From: Chuck Morehead [mailto:cbmorehead@nokuse.com]
Sent: Tuesday, August 28, 2001 7:55 AM
To: midrange-l@midrange.com
Subject: Re: From PC to AS400 data transfer


Sue,

I haven't used this feature in a while, so maybe others on the list can
expand on this.  IIRC, Client Access installed an add-in for Excel - if
Excel was on your PC and you were installing the Data Transfer portion of
Client Access.  I know this let you pull data from the AS/400 into Excel,
but can't recall if the reverse was also true.  If it is, then I would
assume you could use an Excel macro to automate this process.

Perhaps someone else on this list has more experience with this?

Chuck

----- Original Message -----
From: "Sue Underwood" <sue@edataedsi.com>
To: "Midrange" <Midrange-L@midrange.com>
Sent: Tuesday, August 28, 2001 8:49 AM
Subject: From PC to AS400 data transfer


> Greetings,
>
> I have been charged with finding an 'elegant' method for transferring
> information from Excel spreadsheets to the 400.  In this case 'elegant'
> means "without a lot of user intervention".
>
> I'd appreciate your input on the method(s) that you'd recommend and why.
>
> TIA
> Sue Underwood
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
>
>

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com