Word Data Acquisition 101

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JTH - 25 Feb 2005 20:41 GMT

I have VBA code for Excel that gathers the data from a worksheet for export
to another application. The knuckleheads I work for now want the data to be
in a word doc / table instead of Excel. I have not idea where to start with
Word.

Idea #1 - Embed a XLM Excel in the word doc and figure out how to access the
data that way.

Idea #2 - Use bookmarks to index the needed fields????

Idea # 3 - Cry

I have no idea about the Word Object Model. Any ideas??? Starting place???

Signature

JTH

Reply to this Message

Jonathan West - 25 Feb 2005 20:48 GMT

> I have VBA code for Excel that gathers the data from a worksheet for
> export
[quoted text clipped - 13 lines]
>
> I have no idea about the Word Object Model. Any ideas??? Starting place???

The Document object have a Tables collection. Each Table object has a Cell
collection. So if you want the text out of the cell in row 3, column 5, then
this will do the trick

MsgBox ActiveDocument.Tables(1).Cell(3, 5).Range.Text

You may also find this article helpful on the Word object model

Getting To Grips With VBA Basics In 15 Minutes
http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Reply to this Message