J
Joey
Hello! I need some help with setting up a Win2000 DDE server and
connecting an Excel application on the destination machine (the
client) to a third-party DDE quote server located on another machine
(the server).
Here is what my setup is presently and why I need a DDE server set up:
1) I have 2 machines that are linked on a TCP/IP home network and both
run Win2000 Server.
2) On machine A (the server) I run a third-party application that is a
DDE quote feed (it downloads the quotes via the web from the vendor
and provides them via DDE link to Excel).
3) On the same A machine I presently run an Excel spreadsheet that
fetches the quotes from the third-party app quote feed with the
formula format =ThirdPartyApp|<stock symbol>!<field>
4) It works fine
5) For good reasons (a second resources-intensive app that needs the
quotes too) I need to move my spreadsheet to machine B (the client)
and a Win2000 DDE server seems like a good (and fast) solution.
After looking up MS TechNet and a couple of other places, this is how
far I have gone:
1) Put NetDDE.exe in my Startup folder on machine A
2) Enabled NetBUI on both machines (I read a blurb somewhere that the
DDE server uses NetBios)
3) On machine A, created a DDE share named Quotes$ with its static
property named Excel and * in lieu of topic name.
4) I have enabled Trusted Share Properties for this Quote$ share and
check-marked both the “Start Application Enable” and the “Initiate to
Application Enable” options in the Trusted Share property box.
Now I am stumped. I thought that once the above was done, connecting
the spreadsheet from machine B to the server app on machine A would be
as simple as:
1) Start the server app on machine A (it fetches its data from the
vendor’s web server)
2) Modify the DDE formulas in my spreadsheet to point to the quote
feed server via Win2000 DDE server share, as in =Quotes$
ThirdPartyApp|<stock symbol>!<field> , or something to that effect
3) Do I need the share name and machine name in there? What kind of
separators? Wouldn’t be surprised if I have overlooked something major
Help and advice will be much appreciated. Thanks in advance,
Joe
connecting an Excel application on the destination machine (the
client) to a third-party DDE quote server located on another machine
(the server).
Here is what my setup is presently and why I need a DDE server set up:
1) I have 2 machines that are linked on a TCP/IP home network and both
run Win2000 Server.
2) On machine A (the server) I run a third-party application that is a
DDE quote feed (it downloads the quotes via the web from the vendor
and provides them via DDE link to Excel).
3) On the same A machine I presently run an Excel spreadsheet that
fetches the quotes from the third-party app quote feed with the
formula format =ThirdPartyApp|<stock symbol>!<field>
4) It works fine
5) For good reasons (a second resources-intensive app that needs the
quotes too) I need to move my spreadsheet to machine B (the client)
and a Win2000 DDE server seems like a good (and fast) solution.
After looking up MS TechNet and a couple of other places, this is how
far I have gone:
1) Put NetDDE.exe in my Startup folder on machine A
2) Enabled NetBUI on both machines (I read a blurb somewhere that the
DDE server uses NetBios)
3) On machine A, created a DDE share named Quotes$ with its static
property named Excel and * in lieu of topic name.
4) I have enabled Trusted Share Properties for this Quote$ share and
check-marked both the “Start Application Enable” and the “Initiate to
Application Enable” options in the Trusted Share property box.
Now I am stumped. I thought that once the above was done, connecting
the spreadsheet from machine B to the server app on machine A would be
as simple as:
1) Start the server app on machine A (it fetches its data from the
vendor’s web server)
2) Modify the DDE formulas in my spreadsheet to point to the quote
feed server via Win2000 DDE server share, as in =Quotes$
ThirdPartyApp|<stock symbol>!<field> , or something to that effect
3) Do I need the share name and machine name in there? What kind of
separators? Wouldn’t be surprised if I have overlooked something major
Help and advice will be much appreciated. Thanks in advance,
Joe