Copying Merged Excel cells to Word.

[Bernie]

This was posted to excel.programming but no response received :-(

Hopefully some kind person can help....



I have an excel worksheet that contains some merged cells which I need to
copy to Word

I open the word doc with "Set Wordapp = CreateObject("Word.Application")",
copy the required area of the worksheet using "selection.paste" and format
the word page. This is OK except for any merged cells which copy across as
indivual cells in the resultant table in Wword.

How can I overcome this problem as I need to keep the same cell format in
the Word table??

I have built a Word macro to reformat the Word table using "Cell(Row:=10,
Column:=2).Merge MergeTo:=.Cell(Row:=13, Column:=5)" but don't know how to
call this directly from VB in excel.


TIA

Bernie

 

[Dave Peterson]

I don't do enough in word to be useful, but if you don't get a good response
here, you may want to take your question down the MSWord newsgroups.