Solved

External link to AS400 application

Posted on 2001-09-17
6
582 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
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…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

790 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