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.
[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.