Automated import of data from Word to Excel with VBA
Posted on 2016-07-29
I'm after a little bit of advice...
I have a word document that users essentially fill out. It's a relatively large document (50 pages or so) and contains a number of features such as bookmarks and references etc. Once the guys that are completing the document have finished I then need to bring certain pieces of data that they've completed into a 4 page summary.
I've created a template in Excel (at this stage) that will house the desired information in the desired format.
I'm wondering if you guys have some advice on the best way to do this?
Some of the features that will need to be imported include:
- paragraphs from specific sections of the document
- values from tables in the word document
- a number of pictures that they will have placed in predetermined locations in the word document
I was hoping that I could write a script that would find the various references (i.e. locate section 2.5.1 and copy the paragraph / table / picture before pasting it in the corresponding location in the Excel template).
I may have bitten off more than I can chew I'm not sure but keen to get an opinion or two / some good articles that I can use to guide me. Perhaps I need to re-think and revert to PPT instead of Excel.
Any ideas really appreciated.