DDEPoke Help

[Eric D]

Am I doing this right? I cannot seem to get this to work.

I want to populate 2 cells and extract the result of a calculation out of the third cell. I am getting a DDE_SERVICE_INVALID error.

Thanks in advance,



DDEPoke>Excel,c:\data\eric.xls,R4C3,105
DDEPoke>Excel,c:\data\eric.xls,R4C4,500
DDERequest>Excel,c:\data\eric.xls,R4C5,Answer,60
MessageModal>%Answer%

[support]

Is Excel running? The xls file would need to be open.

[Eric D]

Slapping Self


Thanks... I did not know you had to have it running.

Eric

[support]

Hi,

Yeh - otherwise the server does not exist. You wanna do:

ExecuteFile>c:\data\eric.xls
WaitWindowOpen>eric.xls*
DDEPoke>Excel,c:\data\eric.xls,R4C3,105
DDEPoke>Excel,c:\data\eric.xls,R4C4,500
DDERequest>Excel,c:\data\eric.xls,R4C5,Answer,60
MessageModal>%Answer%

or something similar ...

[EUGEBEL]

Hi,

Yeh - otherwise the server does not exist. You wanna do:

ExecuteFile>c:\data\eric.xls
WaitWindowOpen>eric.xls*
DDEPoke>Excel,c:\data\eric.xls,R4C3,105
DDEPoke>Excel,c:\data\eric.xls,R4C4,500
DDERequest>Excel,c:\data\eric.xls,R4C5,Answer,60
MessageModal>%Answer%

or something similar ...

If you use the french release of Excel, this code is running. Just change the Row (R) by the Ligne (L)



ExecuteFile>c:\ewdatas.xls
Wait>10
DDEPoke>Excel,c:\ewdatas.xls,L4C3,105
DDEPoke>Excel,c:\ewdatas.xls,L4C4,500
DDERequest>Excel,c:\ewdatas.xls,L4C5,Answer,10
MessageModal>%Answer%



Regards
Jean-Michel