Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending from excel to word template pizdus Excel Discussion (Misc queries) 0 January 17th 06 05:57 PM
Sending Word Attachment Using a Macro Andy@HycoMan Excel Discussion (Misc queries) 1 October 31st 05 03:58 PM
Send array data from Excel macor to Word Doc using DDEPoke Vijay Chaudhari Excel Programming 0 November 7th 03 07:12 PM
DDEPoke is not working Dipi Excel Programming 0 September 16th 03 10:26 PM
Sending an array to DLL Function Domagoj Vulin Excel Programming 1 July 17th 03 11:08 AM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"