External link to AS400 application

Hi,

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

={IBM123456|SessionA!TRIMRECT}

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)

Thanks,

Marcel

MFreyAsked:
Who is Participating?
 
q2eddieConnect With a Mentor Commented:
Hi, MFrey.

#Questions
1. When you say that you remember a name containing DDE, were you thinking of a macro or a formula?

#Comments
I have seen something like the following mentioned somewhere (just can't remember).

={IBM123456|SessionA!TRIMRECT(a,b,c,d)}

I tried this with our emulator (we also use eNetwork Personal Communications) without any success.

#Links
This probably won't help you any, but just in case...

1. "vbdde.exe - Visual Basic sample using the PC5250 Emulation DDE interface."
http://www-1.ibm.com/servers/eserver/iseries/clientaccess/toolkit/vbdde.htm

If you are going to try this sample code, be sure to change all the application name references.  They are "IBM732032".

Bye. -e2
0
 
amp072397Commented:
MFrey: Can we get some feedback here?

Working on cleaning up this topic area and need all the help we can get.

Thanks.
amp
Community Support Moderator
0
 
MFreyAuthor Commented:
The comments are interesting but they do not solve my problem
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
amp072397Commented:
May I suggest, then, that you post a new, zero-point question here in the Office topic area that contains a link to this question? Perhaps that will bring new/renewed interest to your question.

amp
community support moderator
0
 
amp072397Commented:
MFrey:

You logged in on January 8th and (presumably) saw my comment. Please provide feedback to g2eddie. Troubleshooting problems does not always take a question and answer, but a process.

If you do not respond within about 7 days, I'll award points to g2eddie.

thanks!
amp
community support moderator
0
 
amp072397Commented:
Points awarded to g2eddie.

amp
community support moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.