Which is faster - InsertAfter or Text=

[cjg.groups]

Hello, I am using VBA to put data from Access 2003 queries into Word
2003 tables. Which is the more desirable method for putting text into
a Word table cell:

Document.Tables(i).Cell(r,c).Range.InsertAfter Recordset.Fields(j)
Document.Tables(i).Cell(r,c).Range.Text = Recordset.Fields(j)

This call will be run about 4000 times in 100 Word documents.
Currently, InsertAfter completes this in a few seconds.

Code I got from the newsgroups used InsertAfter, but this requires me
to first delete some existing table text which "Range.Text" would
otherwise overwrite.

 

[Doug Robbins - Word MVP]

I doubt that you would notice the difference, if there is any. That
notwithstanding, the need to remove any existing text would definitely swing
it in favour of using .Text =

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[cjg.groups]

Thanks, I will make this fundamental change to my code.