Opening Excel from AS400 -- MIDRANGE-L

Subject: Opening Excel from AS400
From: Vinay Gavankar <vinaygav@xxxxxxxxx>
Date: Sat, 16 Jan 2010 14:58:12 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Is it posible to write a CSV file to IFS and open it in Excel, seamlessly
from an AS400 program?

This is what I want to do:

Program will display data from a file. When user presses an F key (Export to
Excel), Excel is started in a new window with that data. User can then save
it whereever he wants on his PC.

I was thinking that a CSV file could be written somewhere on IFS and then
maybe STRPCCMD (or something similar) can open Excel with that file. I don't
know whether such a thing is possible.

There is no specialized software on AS400, and getting any new software
installed, is not an option.

Any ideas?

Follow-Ups:

Re: Opening Excel from AS400 , Scott Klement

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.