See the article "Control Excel from Word" at:

http://word.mvps.org/FAQs/InterDev/C...XLFromWord.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
wrote in message
oups.com...
Greetings,

I'm a seasoned software person who's never touched VBA or any kind of
Microsoft application programming, and I find I have a problem I need
to solve quickly. I could probably muddle through books and bash my way
to a solution in a few days, but any pointers as to the right direction
would be GREATLY appreciated!

In short, I have a Word document with a few hundred bookmarks; each
bookmark highlights a bit of requirement text (actually, more than one
document, but I digress...)

I need to create an Excel sheet that has one row per requirement.
There needs to be a column that captures the bookmarked text from the
Word document, and another column with a hyperlink to that bookmark.

Again, I have yet to look at a single line of VBA code. Can anyone
point me towards the right objects, methods, etc.? I suppose I need to
iterate through a bookmark collection, extract the text, and add a row
to the spreadsheet.

Also, where would I actually code this... in the Excel application, or
the Word application (or does it matter)?

Thanks much for any pointers!

Dan Masi