Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Com with Word
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 has 50 X 1 array dim(string) Application.DDEPoke channelNumber, "\Startofdoc", _ rangeToPoke X = X + 1 Loop Application.DDETerminate channelNumber '----------- Thank you for your help! Vic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) |