Joe,

Not exactly sure how it should work. The users have developed a Cell
Scheduling Calculator in Excel. Of course, the BOM and Routing Data are
originally maintained in the i5. So, when the BOM and/or routings
change on the i5, they do not want to have to also make the manual data
entry changes in the Excel.

Also, things like having a code field in the Excel which signifies if a
component is Purchased. Then, if a part gets changed from Mfg. to
Purchased, or vice-versa, in the i5, that should also be reflected in
the Excel "code" field.

Other things as well - just not sure what they may be now.

Thanks,
Don

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Wednesday, September 17, 2008 12:38 PM
To: Midrange Systems Technical Discussion
Subject: Re: Getting AS/400 Data to Link Real-Time to Excel

Don Cavaiani wrote:
Anyone doing this now? Where an updated record on the i5, will be
updated in the spreadsheet, AND deleted i5 records will be deleted from
excel, AND added i5 records will be added to excel?

I can't help with the mechanics, but I'd be interested in the business
scenario - are you talking about someone sitting in an Excel document,
having it open, and as data changes on the i, the spreadsheet columns
flicker and jump on their desktop?

Or is it more of the user wanting the very latest data whenever they
open the worksheet?

I thought there were some sorts of realtime links using client access
that would pull down data from the host when you opened the spreadsheet,
but I may be mistaken. If not, an option is to rebuild the spreadsheet
each time a file event occurs and then have the user copy the current to
a local folder and open the copy.

Joe

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].