That is how I learned it.
Tom
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Richard Schoen
Sent: Wednesday, February 09, 2011 12:11 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Iseries file to an Excel spreadsheet
Further to Toms response, our RPG2Excel functionality that Vern mentioned
has full VBScript access to the spreadsheet, but from a simple RPG program.
Imagine automating MS Excel directly from RPG or CL.
Feel free to contact me or Vern offline or request a 30 day trial from our
web site.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 3
date: Wed, 9 Feb 2011 10:29:36 -0600
from: "Tom Huff" <tehuff@xxxxxxxxxxxxx>
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
midrange.com
