Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Initiate a trigger for clearing a list of check boxes? | Excel Worksheet Functions | |||
How can a macro automatically initiate uponing a file? | Excel Discussion (Misc queries) | |||
Initiate perl script in linux from a Windows VBA program | Excel Programming | |||
Initiate Macro Formula :: Combo Boxes | Excel Programming | |||
Shell Command to initiate Linux program | Excel Programming |