|
midrange.com
I am running CAE V5R1M0.
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:57
PM
Please respond to
rpg400-l
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.
