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?
writing to a merged cell in Excel
Moderators: JRL, Dorian (MJT support)
-
- Junior Coder
- Posts: 36
- Joined: Fri Oct 12, 2007 5:55 pm
- Location: federal way wa
- Contact: