Hi,
I have a problem to link two excel5 sheets that are one on a server and
other on a client. If i use this procedure to share server sheet it
work:
1) Establish a DDE coonection with client using WINCHAT
2) Copy content of server sheet in the clipboard (using copy command
of excel)
3) Share the content of the clipboard (on the server)
4) On client,connect to shared clipoard of server and copy it in
local clipboard
5) Paste content of clipboard on client sheet
In excel link properties of client sheet i found this:
\\Server\NDDE$|$clipb.ole|server.xls!R1C1:R20C4
| | |
Server Name | my server sheet
|
name of shared clipboard
I want do this using VB 4/5 .
Can you help me ????