ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   interfacing Excel to nonOffice application via DDE (https://www.excelbanter.com/excel-programming/336666-interfacing-excel-nonoffice-application-via-dde.html)

Martin Hallerbach

interfacing Excel to nonOffice application via DDE
 
Hi,

I'm communicating as mentioned above, using DDE commands in Excel 2003 SP1
VBA.
The DDE-link establishes and I can send and receive data, especially
RECEIVE.Send data (ddepoke chan,item,data) appears to work OK (no error
messages, all status information looks OK) but nothing happens on the
receiving end (Information which should be altered, didn't change at all,
when doing a dderequest on the same storage location into which i ddePoked a
zero (for instance).

If I use an old makro template in excel4.0, which does exactly the same
thing as I want to do utilizing VBA, all runs sufficiently (sent data can be
DDERequested, DDEExecutions work properly etc pp).

any suggestions??

Thx a lot in advance
--
Martin


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com