I would like to thank everyone for all the information. I have decided to create the data transfer inside the Excel program. This seams the easiest and fasted way to do it at this time. Will continue to try and automate it more as time allows.
Thanks again to all,
William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Huff
Sent: Wednesday, February 09, 2011 8:30 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Iseries file to an Excel spreadsheet
William,
You can also use a VB script kicked off in excel by a button to go to the Iseries and extract data and return it to the spreadsheet. Requires some cl and rpg programming as well as VB scripts.
Tom
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Willie J. Moore
Sent: Wednesday, February 09, 2011 9:11 AM
To: 'RPG programming on the IBM i / System i'
Subject: RE: Iseries file to an Excel spreadsheet
I did, but after 3 days no answer. Thought I would try this forum.
William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Larry Ducie
Sent: Tuesday, February 08, 2011 3:03 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Iseries file to an Excel spreadsheet
Hi Willie,
<snip>
DCL = Declare CL Variable.
I want to do the update from within an CL.
</snip>
This is the RPG forum - you really DO need to post this question on MIDRANGE-L
Cheers
Larry Ducie
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
