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 |
VBA, Bookmarks, Word and Excel... help please!
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 |
VBA, Bookmarks, Word and Excel... help please!
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" wrote in message ... 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 |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com