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