VBA, Bookmarks, Word and Excel... help please!

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

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
<danmasi@earthlink.net> wrote in message
news:1108316078.456338.235690@c13g2000cwb.googlegroups.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
>

Both Excel and Word have macro recorders. To get help with syntax, turn on
the macro recorder found under the tools=>Macros menu and perform the action
manually. (for example edit a bookmark).

Then turn it off and look at the recorded code. It will have thinks like
Object.select selection.Property = code because that is what you did
manually. Generally you can replace the select / selection pair and put the
property with the object.

--
Regards,
Tom Ogilvy

"Doug Robbins" <dkr@NOmvpsSPAM.org> wrote in message
news:%23cSsRlgEFHA.2700@TK2MSFTNGP14.phx.gbl...
> 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
> <danmasi@earthlink.net> wrote in message
> news:1108316078.456338.235690@c13g2000cwb.googlegroups.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
> >
>
>