I have problem with DDE! I use this technology to exchange data from external application (Metatrade 4 used for currency trading) into Excel.
Problem is very selective! Vast majority of tickers representing trading instruments works fine. But in several cases, there is no way to store link in correct format into the Excel!
My entered link is corrupted after insertion. I mean entered quotation marks ' ' are lost!
Example of working link:
my entry ='MT4'|BID!'[DAX40]' | stored content in the Cell ='MT4'|BID!'[DAX40]' | as you can see entry link = stored content into the Cell | all correct!
Working instruments:
V?běr 1.png
Example of working result
V?běr 3.png
Problematic link:
my entry ='MT4'|BID!'[FTSE100]' | stored content in the Cell ='MT4'|BID! [FTSE100] | as you can see single quotation marks ' ' were lost, Excel removed them of the Cell, DDE link doesn't work! Why??
Problematic instruments:
V?běr 2.png
Example of not working result
V?běr 4.png
Thanks!
Bookmarks