?
Solved

External link to AS400 application

Posted on 2001-09-17
6
Medium Priority
?
587 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 7

Accepted Solution

by:
q2eddie earned 800 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

765 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