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
 

--------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Excel for Windows, versions 5.0, 5.0c
 - Microsoft Excel for Windows 95, version 7.0
--------------------------------------------------------------------
 
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
 
   ='\\<computer name>\<share name>\[BOOK1.XLS]SHEET1'!$A$1
 
where:
 
   <computer name> is the computer's network name
   <share 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.
