External link to AS400 application
Posted on 2001-09-17
I would like to link some Excel cells to a screen of an AS400 screen (using eNetwork Personal Communications).
I can make a copy link in the AS400 client and paste it as a link in Excel, but it only works for the selected area, it produces the following formula
I would like to specify some specific areas and link them to different Excel cells. The application would of course only work when the correct screen is displayed in the AS400 application. I have done the same thing with a Samba client a few years ago, but I can not remember the formula I used (but I think the name contained DDE)