VBA - Word Document Bookmarks extracted into Excel Sheet Text Box's

[PHayes35]

I'm looking to find code that takes bookmarks on word and copy/paste's those bookmarks into text box's in an Excel Workbook (keeping text formatting). The reason for this is that it's much easier to write and format in Word, and this would save time in copy and pasting these paragraphs.

If anyone could point me in the right direction that would be much appreciated.


Thanks!

 

[Macropod]

Creating bookmarks for something you've formatted in Word, just so you can automate Word or Excel to save you the effort of a copy/paste into a textbox somewhere in an Excel workbook is likely to be a whole lot more work than simply doing the copy/paste without a macro. For example, how would a macro know which bookmark in Word document relates to what textbox in an Excel workbook?