Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send array data from Excel macor to Word Doc using 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
How to create a macor to count the usage of another macor | Excel Discussion (Misc queries) | |||
i need to create an invioce in EXCEL and then send it into a WORD. | Excel Discussion (Misc queries) | |||
DDEPoke is not working | Excel Programming |