1

I try to use this method to export a table from excel to word, however i cannot export correctly because the merged cells appears unmerged.

But the problem is that the format does not include the merged cells, also i noticed that the customized colors are not copied correctly to word.

WordFormatting Required Boolean True formats the table using the formatting in the Word document. False formats the table according to the original Excel file. 

objword.Selection.pasteexceltable False, False, True

Could you help me please?

Arroyo Danowsky
  • 11
  • 1
  • To copy format you must for each cells in Excel copy format to correspondimg cell in Word. Any format property copy use self assignment operator. – Ivan.s Apr 16 '20 at 05:48
  • About merge cells see [answer](https://stackoverflow.com/questions/22075988/detect-merged-cells-in-vba-excel-with-mergearea) and megre corresponding word cells. – Ivan.s Apr 16 '20 at 06:05

0 Answers0