Microsoft KB Archive/141290

How to Create a DDE Link to a Worksheet on Another Computer

PSS ID Number: Q141290 Article last modified on 01-17-1996

5.00 5.00c 7.00

WINDOWS

= SUMMARY =

This article contains an example of the syntax you must use to create a DDE link to a cell in a Microsoft Excel worksheet that is located on another computer.

Note that the other computer must be connected to your computer over a network.

= MORE INFORMATION =

To create a DDE Link from one Microsoft Excel worksheet to another Microsoft Excel worksheet, make sure the source file is in a shared folder or directory. If you are not familiar with sharing directories or folders on a network, consult your system administrator.

Open the dependent workbook in Microsoft Excel. In the cell where you want to create the link, enter the following formula

=‘\ [BOOK1.XLS]SHEET1’!$A$1

where:

is the computer’s network name is the name of the share [BOOK1.XLS] is the .XLS worksheet you wish to link to SHEET1 is the name of the Sheet $A$1 is the cell

Dynamic Data Exchange (DDE) is a protocol that permits two programs to communicate by continuously and automatically exchanging data through a DDE “channel.”

= REFERENCES =

Microsoft Press: “Developing Microsoft Excel Solutions,” version 5.0, pages 603-604

KBCategory: kbinterop kbnetwork kbusage kbhowto KBSubcategory: xlwin

= Additional reference words: 5.00 7.00 =

Copyright Microsoft Corporation 1996.