Have you tried to use the "add in" feature in excel...it works very well...
----- Original Message -----
From: "Willie J. Moore" <WJMoore@xxxxxxxxxxxx>
To: "rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, February 8, 2011 4:07:30 PM
Subject: Iseries file to an Excel spreadsheet
I have posted this on the Midrange-L site with no response. I thought I would try here and see if I have better luck.
I have a file on the iseries and an Excel spreadsheet.
Spreadsheet name=open percentages.xa.2011, worksheet name=wek%2003.
I want to copy the iseries file into the spreadsheet, replacing the data in the worksheet. I have a 'DCL' with the spreadsheets name. I am having trouble replacing the spreadsheet data with the file data.
File layout: date, total orders, total items, prod due & prod due %.
Excel spreadsheet: date, total orders, total items, prod due & prod due %.
Any help would be greatly appreciated.
Thank you,
William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 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
