Solved

External link to AS400 application

Posted on 2001-09-17
6
579 Views
Last Modified: 2008-03-03
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

0
Comment
Question by:MFrey
  • 4
6 Comments
 
LVL 7

Accepted Solution

by:
q2eddie earned 200 total points
ID: 6500647
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
 

Expert Comment

by:amp072397
ID: 6712245
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
 

Author Comment

by:MFrey
ID: 6714797
The comments are interesting but they do not solve my problem
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Expert Comment

by:amp072397
ID: 6716452
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
 

Expert Comment

by:amp072397
ID: 6743918
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
 

Expert Comment

by:amp072397
ID: 6757303
Points awarded to g2eddie.

amp
community support moderator
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now