LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general,microsoft.public.word.vba.beginners
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bookmarks in Excel??? Phil Excel Worksheet Functions 4 February 13th 12 10:03 AM
Cross reference bookmarks in a Microsoft word document FredN Excel Discussion (Misc queries) 0 April 7th 08 04:33 PM
Creating Excel bookmarks Louise Excel Worksheet Functions 1 January 21st 05 06:54 PM
Checking for bookmarks in Word document jag Excel Programming 2 June 14th 04 02:15 AM
Using Word Bookmarks to read Text Charles Excel Programming 2 February 12th 04 03:40 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"