ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   DDE Initiate does not work (https://www.excelbanter.com/excel-programming/313128-dde-initiate-does-not-work.html)

Ferenc Nagy

DDE Initiate does not work
 
Hi!
This is an Excel Macro.
I want to pass data from Excel to another program,
running in a command window.

Sub Macro2()

Dim channelNumber As Long
Application.DisplayAlerts = False

channelNumber = Application.DDEInitiate("PE2", "new.txt")
Set rangeToPoke = Worksheets("Sheet1").Range("A1:C2")
Application.DDEExecute channelNumber, "e x"
Application.DDEExecute channelNumber, "[cursor data]"
Application.DDEPoke channelNumber, "[cursor data]",

rangeToPoke
Application.DDEExecute channelNumber, "[mark line]"
returnList = Application.DDERequest(channelNumber,

"Topics")
For i = LBound(returnList) To UBound(returnList)
Worksheets("Sheet1").Cells(i, 1).Formula =

returnList(i)
Next i
Application.DDETerminate channelNumber

End Sub

The Pe2 program has started but
why have I got Run time error 13 "type mismatch" at this
line:
channelNumber = Application.DDEInitiate("PE2", "new.txt

What can I do instead of DDE calls?
Regards
Ferenc Nagy



All times are GMT +1. The time now is 04:14 AM.

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