writing to a merged cell in Excel

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
MacschedStudent
Junior Coder
Posts: 36
Joined: Fri Oct 12, 2007 5:55 pm
Location: federal way wa
Contact:

writing to a merged cell in Excel

Post by MacschedStudent » Sun Oct 14, 2007 4:45 pm

Hey guys I'm writing from a text file to a spreadsheet using DDEPoke. Everything works great until I attempt to write to a merged cell here is the line of code:


Let>CurrentLine=Lines_1
DDEPoke>Excel,e:\test.xls:Sheet1,R2C1,CurrentLine

and I get the following error msg



"Cannot change part of a Merged Cell"




any way to get around that? Also if there is data there already how would you make sure the new data is in front of the existing data?

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