Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
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
Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) Tom-LE Excel Discussion (Misc queries) 0 August 30th 06 10:10 PM
My send to in excel/word does not offer send as attachment Mstink Excel Discussion (Misc queries) 11 March 16th 06 02:49 PM
How to create a macor to count the usage of another macor Jigu Excel Discussion (Misc queries) 0 March 11th 06 03:28 AM
i need to create an invioce in EXCEL and then send it into a WORD. cassie Excel Discussion (Misc queries) 1 March 12th 05 07:49 PM
DDEPoke is not working Dipi Excel Programming 0 September 16th 03 10:26 PM


All times are GMT +1. The time now is 02:36 AM.

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"