DDE Links and WIN2000

[Riegg]

I have a script that works just fine in 98 but when I run it under 2000 I can't get the DDE "stuff" to work. Anyone have luck with DDE in 2000??

 

[knob]

I'll have to try this on my Win2K laptop at home, but I'm not aware of any problems. Are you communicating with Excel or a different application? Are you using the same versions of Procomm on both machines? In version 4.8, the DDE topic is PW5 (incorrectly mentioned as PW4 in the help files), while PW4 is used for previous 4.x versions.


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[Riegg]

Nope just Excel, and it is the same version of Procomm on both. Now what is this about "the DDE topic is PW5"?? (It's 4.8 on both partitions; same machine)

 

[knob]

The server name (I used the wrong bit of jargon, forget topic) is what is used by other applications to control Procomm. This is when Procomm is acting as a DDE server instead of a DDE client (which is what it is called when Procomm requests information from other applications). However, this shouldn't matter in your case since Procomm is controlling Excel and not the other way around, I assume.

At

http://www.aspectscripting.com/samples.html

I have a couple DDE samples provided by Hank. You might want to take a quick look at those and see if those work successfully on your Win2K machine (it will be a little while tonight until I can fire up the laptop). One other thing to check is that the paths to Excel are the same on both machines, particularly if they are different versions of Excel.


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[Riegg]

Oh, ya it's procomm that is controlling excel. The path is the same since it does bring it up (run excelpath ; where excelpath is setup in a user box.) The command that is giving me problems is:



ddeinit excelch "excel" "system"

 

[knob]

Sorry, I forgot to get to this last night. I'll look into it tonight unless I happen to switch one of my work machines to Win2K today.


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[knob]

I used the DDE_EXCEL_TO_TEXT.ZIP script on my samples page and it worked fine on my Win2K laptop. If you want to post your script, I can look it over and see if I notice anything, but it's odd that it works on Win98 and not Win2K.


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[Riegg]

yes I found it very odd... now the problem is that my script is over 2000 lines so posting it is all most out of the question. But now that I know it works, and there are no issues I will go back and work on it.

Thanks

 

[knob]

You might try just the ddeinit section of code by itself and see if you can get it (or the sample DDE code from Hank on my site) to see if you can get just that to work. There are a couple problems in other areas with ASPECT on Win2K - the one that jumps to mind at the moment is a couple of the file-related commands (sdlgfsaveas, sdlgfopen, and dir). These commands don't return the expected results under Win2K, so that may be causing your script some fits.


aspect@aspectscripting.com

http://www.aspectscripting.com

 

[Riegg]

well just more things for me to check..... ARGH!!
Thanks for the heads up on the sdlgfsaveas and sdlgfopen as I use both in the script. That's it I am just going to stamp "Do Not Use In Win2000" on it and send it out.

Thanks