Word Automation - Slow

[Jonathan Wareham]

Hi,

I have finished an app that generates a Word document from RTF text stored
in records in a SQL database. Everything works great, other than the fact
that the automation code to build the document doesn't particularly run very
fast to say the least.

I've had a look around and it seems this is a common problem with Word
automation. Does anybody have any tips for speeding things up, other than
using early binding and With..End With.

Thanks,

Jonathan

 

[Cindy M -WordMVP-]

Hi Jonathan,

I have finished an app that generates a Word document from RTF text stored
in records in a SQL database. Everything works great, other than the fact
that the automation code to build the document doesn't particularly run very
fast to say the least.

I've had a look around and it seems this is a common problem with Word
automation. Does anybody have any tips for speeding things up, other than
using early binding and With..End With.

One possibility would be to build the document as an RTF or HTML file (Word
has a "round-trip" HTML syntax since version 2000). This would mean you could
work with pure text, rather than having to automate Word, and at the end open
it in Word (and use File/Save As to create a Word document, if required).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail