#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default NetDDE

Hi reklamo.

Three steps are necessary:

1. enable and start "Network DDE DSDM" and "Network DDE" in both pc's

2. on serverside, each share expose to network a single server-topic pair; in excel you can expose a single file per share.
Run ddeshare utility (from start-run.. ddeshare); create new share, and name it; then in each of three rows you must insert:
App name: excel.sheet
Topic name: your_excel_file_pathname


3. link your 'client' cells with remote sheet cells

='\\serverhostname\NDDE$'|sharename!'!sheetname!R1 C1').


WARNING! DDE is an older technology that is not secure!
Reference: last part of Microsoft KB238133

Good luck!
Lorenzo



On Friday, April 23, 2010 3:14 AM reklamo wrote:


I have an open workbook on PC 1 in which values are updated every second. I
want to transfer some cells (values) to an other workbook on PC 2. How is
this possible with NetDDE?
Thanks for help in advance
reklamo




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NetDDE DDEShare and Excel [email protected] Excel Programming 1 June 24th 06 03:59 PM
NetDDE Windows XP SP2 saleem145 Excel Discussion (Misc queries) 0 June 23rd 06 05:42 PM
NetDDE in Excel 2003 mnstargazer Excel Programming 1 January 26th 05 11:53 AM
NetDDE problem - from a non-interactive session Diego Zeballos Fraigne Excel Programming 0 March 2nd 04 11:41 PM


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"