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 |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com