|
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 ] The Excel add-in is one way, (400 -> PC). >From your CAE 5250 session, select Send File to Host from the Transfer drop down menu. HTH, 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: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com] Sent: Thursday, November 01, 2001 12:58 PM To: rpg400-l@midrange.com Subject: Re: Downloading Excel File to Physical File Rob, At which version of CAE? I have V4R5M0. It only goes one way Thanks, Mark Mark Walter Sr. Programmer/Analyst Hanover Wire Cloth a div of CCX, Inc. mwalter@hanoverwire.com http://www.hanoverwire.com 717.637.3795 Ext.3040 rob@dekko.com Sent by: To: rpg400-l@midrange.com rpg400-l-admin@mi cc: drange.com Subject: Re: Downloading Excel File to Physical File 11/01/01 03:40 PM Please respond to rpg400-l Surprise, it goes both ways. Rob Berendt ================== "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin MWalter@hanoverwi re.com To: rpg400-l@midrange.com Sent by: cc: rpg400-l-admin@mi Fax to: drange.com Subject: Re: Downloading Excel File to Physical File 11/01/2001 03:07 PM Please respond to rpg400-l Rob, I wasn't aware that you could move data TO your AS/400 with this add-in. I don't use it much but I thought it was only a download not upload. Thanks, Mark Mark Walter Sr. Programmer/Analyst Hanover Wire Cloth a div of CCX, Inc. mwalter@hanoverwire.com http://www.hanoverwire.com 717.637.3795 Ext.3040 rob@dekko.com Sent by: To: rpg400-l@midrange.com rpg400-l-admin@mi cc: drange.com Subject: Re: Downloading Excel File to Physical File 11/01/01 03:00 PM Please respond to rpg400-l Probably better served on the midrange-l group. If you have one of the proper flavors of Client Access there is a method in Excel to do a transfer a file from/to excel to a file. Here's a start: Client Access Express provides a Microsoft Excel add-in for data transfer which allows you to run download and upload transfer requests from the 32-bit versions of Microsoft Excel. You must first install the Microsoft Excel add-in in order to transfer data from the host system to a spreadsheet. If Microsoft Excel was installed on your PC before Client Access Express, the Client Access Express setup program will automatically install the Microsoft Excel add-in when you choose to install Data transfer Excel Add-in support. This support is installed during a typical and full install, but may not have been installed in a custom or 5250 install. If Microsoft Excel was installed on your PC after Client Access Express: 1 Ensure that you installed Data Transfer Excel Add-in support when you installed Client Access Express. This support is installed during a typical and full install, but may not have been installed in a custom or 5250 install. Click here for information on installing a Client Access Express component. 2 Open Microsoft Excel. 3 Select Tools > Add-Ins. 4 Click Browse. 5 Locate the path in which you installed Client Access Express. 6 Double click the shared folder. 7 Double click the cwbtfxla file. 8 Click OK. Now you will be able to click on the data transfer toolbar icon that appears on your Microsoft Excel toolbar. You can also run a data transfer request by selecting Transfer Data From AS/400 from the Data menu. I had to do a search on cwbtfxla* to find this bugger. Rob Berendt ================== "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin JMBauman@wardtruc king.com To: rpg400-l@midrange.com Sent by: cc: rpg400-l-admin@mi Fax to: drange.com Subject: Downloading Excel File to Physical File 11/01/2001 02:18 PM Please respond to rpg400-l Hi Everyone. I need to download an excel file into a physical file. I was just going to download it to a non-dds file and use it as a program described file but I thought I would run it by the group. Thanks in advance for all your help John M. Bauman Lead Programmer Ward Trucking Second Avenue & Seventh Street, Greenwood Altoona, Pa 16602 Voice: (800) 458-3625 Ext. 284 Voice Direct: (814) 947-1284 (Direct Line) Fax: (814) 944-5470 JMBauman@Wardtrucking.com Visit our website at http://www.wardtrucking.com _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
