Solved

External link to AS400 application

Posted on 2001-09-17
6
586 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 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
Independent Software Vendors: 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

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.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

695 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