Word 97 and XML

[Kirk]

I am constrained to using Word 97 in my programming due to
costs. I want to use Word for reporting purposes. I can
automate Word in VB to do this but what I would like to do
is to use an XML stream from a web site to feed data
elements in Word. I've thought about mergefields and
bookmarks to do this. I can't find a way to feed the data
stream into Word directly. I create the xml from an asp
which has a content type of "text/xml". I create an ADO
connection and send the recordset as a response. The
streaming works great it's just connecting it to Word that
is the problem

I may be making this too hard also. There might be a more
straightforward solution. I am willing to entertain a
middle piece of code as well if suggested.

Kirk

 

[Cindy Meister -WordMVP-]

Hi Kirk,

There is no way to "dump" an ADO or other kind of data stream
directly into "targets" in a Word document. You have to use
VBA to take the data apart and put it into the targets.

Or, for mail merge, change the data into a delimited string
format, dump the string into a Word doc (or text file, but
you'll have fewer problems with a *.doc file format), save
it, and use that as the mail merge data source.

I am constrained to using Word 97 in my programming due to
costs. I want to use Word for reporting purposes. I can
automate Word in VB to do this but what I would like to do
is to use an XML stream from a web site to feed data
elements in Word. I've thought about mergefields and
bookmarks to do this. I can't find a way to feed the data
stream into Word directly. I create the xml from an asp
which has a content type of "text/xml". I create an ADO
connection and send the recordset as a response. The
streaming works great it's just connecting it to Word that
is the problem

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

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