DDE to UDF. DDE formula causes Excel to crash

[Philb1]

Hello
For Christmas I received a Razer keyboard/mouse combo, installed the Synapse software & started playing with it as you do & found that when I tried opening an excel file with DDE formulas, excel opened & then froze up. I tried a multitude of ways to open a file & unless it was a file without any DDE formulas, it wouldn't open. I uninstalled the software & everything returned to normal. I dug out an old Logitech keyboard/mouse combo, installed the Setpoint software & got exactly the same thing. I found that even with a new blank workbook, a DDE formula manually typed in will cause excel to freeze as soon as enter is pressed. I did some googling & it seems that DDE is an ancient protocol & should be phased out eventually, so I don't expect to much in the way of assistance from the hardware people. It seems that you have to convert the DDE formula to a UDF formula. I've read that you can convert the document from DDE to UDF, but I can't find how, at least not in plain English I can't. Not only that, how can I do that if I can't open it. I'm presuming any solution is going to be via VBA. Below is a link to one of the places I've looked at
Any ideas? I haven't lol
Cheers

http://documentation.caseware.com/la..._Protocols.htm

[xladept]

It looks as though you just put "cw_" in place of the penultimate pipe and drop the last pipe - did you try that??

[Philb1]

Hi xladept
I haven't tried anything yet, the markets are closed until Monday, so no data is being transmitted. I thought there may be more to it than just a simple change, I hope I'm wrong. The DDE formulas I use look like this

Please Login or Register  to view this content.

There's just the one pipe. The formulas on the linked page, I think, are what they look like after excel has converted them. I can't open them to convert them at the mo.
I'm fishing to see if anyone has seen & overcome this problem already
Cheers
Phil