Re: Direct update to Excel spreadsheets

How about a VB or VRPG program that is launched from the iSeries that runs
on THAT PC with RUNRMTCMD?

It could use the necessary Office automation methods to extract the data
from the specified cells in the spreadsheet.  This program could then either
put this data into a file and transfer or FTP it to the iSeries, or it could
send it as data queue entries to a data queue on the iSeries where a program
will receive them and process them.

Steve

----- Original Message -----
From: <rob@xxxxxxxxx>
To: <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Wednesday, December 17, 2003 9:47 AM
Subject: Direct update to Excel spreadsheets


> The PHB is purchasing this application that runs on a PC.  It will poll
> the PLC's and update well defined cells in an Excel spreadsheet.  Now he
> wants a tool that will run on the iSeries that will go out to that PC,
> open up that spreadsheet, and extract data from just those cells.
>
> Years ago I had looked at an application that would not only read, but
> could update, cells on a Lotus spreadsheet stored in a shared folder on
> the 400.  I've lost all documentation on that product.  My question is
> "Anyone know of such a product?"
>
> Boss does NOT want the PC's spreadsheet stored on the iSeries.
>
> My argument was to use a socket program on the iSeries to poll the PLC's
> directly but I lost out.  Goes to show you that sometimes you need to take
> the time to learn new technology even when you don't have a current need
> so that you can be more useful, immediately, when the need arises.  "One
> of these days" I'll take that sockets tutorial.
>
> Rob Berendt
> --
> "All creatures will make merry... under pain of death."
> -Ming the Merciless (Flash Gordon)
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>