Excel DDE sheet name and cell range

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
iwadmin
Newbie
Posts: 6
Joined: Thu Jun 29, 2006 8:35 am

Excel DDE sheet name and cell range

Post by iwadmin » Tue Jul 04, 2006 9:50 am

I have found the method for addressing the sheet name and the cell ranges directly through DDERequest or DDEPoke.

Define destinationfile, nameofthesheet (it can contain spaces) and datatobeaddedseparetedbytabs as you wish...

Define the range of cells:
R2C1:R100C20 (you can use %variables% in place of the numbers)

then use the DDE commands:

DDEPoke>Excel,%destinationfile%:%nameofthesheet%,%XLRange%,%datatobeaddedseparatedbytabs%

Hope it is useful...

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts