Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending array data to Word with DDEPoke
Hi,
I am trying to send array data from Excel macro to an open Word document using DDEPoke, however, it is not puting the data in the Word Document. Here below is a sample of the code in Excel macro: '--------- channelNumber = Application.DDEInitiate( _ app:="WinWord", _ topic:="C:\WUTEMP\TEMP.DOC") X = 1 Do While X < 4 rangeToPoke = List_Part_No(X) 'List_Part_No is an array with 3 data(string) Application.DDEPoke channelNumber, "\Startofdoc", _ rangeToPoke X = X + 1 Loop Application.DDETerminate channelNumber '----------- Thank you for your assitance! Vijay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending from excel to word template | Excel Discussion (Misc queries) | |||
Sending Word Attachment Using a Macro | Excel Discussion (Misc queries) | |||
Send array data from Excel macor to Word Doc using DDEPoke | Excel Programming | |||
DDEPoke is not working | Excel Programming | |||
Sending an array to DLL Function | Excel Programming |