SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I've come up against a problem. My knowledge of the Word object model is sketchy, and I'm trying to find a way to identify which bookmark I'm at.
A bit of detail...
A large word doc has numerous links to an even larger Excel file. I want to replace the links with bookmarks, so that I can loop through them and pull in the corresponding Excel tables.
I don't think it will be a problem to loop through all of the bookmarks and get the data, but if I'm at a specific bookmark in the middle of this doc, how do I find out which bookmark I'm at? Excel has ActiveSheet, Selection, and several other useful shortcut refs. Is there such a beast for Bookmarks in a Work document?
Thanks
Denis
A bit of detail...
A large word doc has numerous links to an even larger Excel file. I want to replace the links with bookmarks, so that I can loop through them and pull in the corresponding Excel tables.
I don't think it will be a problem to loop through all of the bookmarks and get the data, but if I'm at a specific bookmark in the middle of this doc, how do I find out which bookmark I'm at? Excel has ActiveSheet, Selection, and several other useful shortcut refs. Is there such a beast for Bookmarks in a Work document?
Thanks
Denis