Thread: Pasting several excel ranges into Word - Format Problem

Hello,

Im wondering if anyone has come across this problem before.

Im currently in the process of debugging a procedure that runs through a loop copying multiple ranges from excel and pastes them into Word.

The format in excel needs to be retained and using the .Paste appears to work fine pasting the table as HTML as expected, however, after a certain number of table inserts the formatting reverts to RTF for no apparent reason (calls the exact same paste procedure each time). Even setting the word data type to HTML and .PasteExcelTable still results in the RTF table.

Secondly, does anyone know why the pasting of a large table (900 rows of excel data) takes over 5 minutes to paste yet if its split into two it takes no time at all or upto approx 700 rows is also instant. I have adjusted numerous settings including switching to normal layout and removing repagination aswell as all grammar and spell checking.

Im using Word and Excel 2003.

Thanks

McCrimmon

Why don't you use Word's builtin facilities to perform these tasks ?

Sub snb()
  activedocument.content.InsertFile "E:\OF\adressen 001.xls", "A1:G20"
End Sub