Extracting data from Word document to populate Excel spreadsheet

Having nested tables, possibly with varying numbers of internal tables, makes what you're proposing to do unnecessarily complicated. Is there a reason you must have nested tables? That said, try something based on:

Please Login or Register  to view this content.

The macro has its own file browser, so it will automatically process all documents in the selected folder.

The document in your link appears to have nested tables (ie one table inside another) for the 'Work' and 'Sample Reply'.

The code goes into your Excel workbook. For macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm. Although these are for Word, the principles for Excel are the same.

As for:

I was banking on a very similar macro to the one I will eventually need

That's a tall order given the sparseness of the information you've given. I suggest you install the macro and run it, then post back if you have any issues with it.

You'll see a comment at the top of the code about a reference to the Word object model being required. That's because the code uses what is called 'early binding'. To add the required reference, open your Excel file, open the Excel vbe (Alt-F11), select your file from the left panel, then Tools|References and, from the dropdown scroll down till you see "Microsoft Word # Object Library" and select it.

Did you look in the worksheet? Does the folder have documents of the kind displayed in your link? Do those documents have data in the cells to populate the worksheet with?

Because I had to copy & paste your GoogleDoc from your link into Word, it's possible the structure changed somewhat in the transition. That wouldn't have been an issue had you attached it to a post here, which you can do via the paperclip symbol on the 'Go Advanced' tab. If you can do that, I'll take another look at it - the code certainly works fine with the converted copy.

OK, the issue was just a trivial 'left-over' from my testing. In the macro in your workbook, you'll find the line:
strFile = Dir(strFolder & "G*.doc", vbNormal)
Change this to:
strFile = Dir(strFolder & "*.doc", vbNormal)

The macro ran fine for me with your 'Pretesting Items.docx'.

Hello Paul,

I've been searching for a solution, very similar to this. I am new to VB but have used your code and the test file successfully. I have created a second document and see that everything from the folder pulls into the Excel sheet.

This is amazing Paul, thanks for sharing.

What I need goes a step beyond, and I'm hoping you can help me with this.

My Word doc is a form with information such as Model and Serial Number. I need to have the information placed in certain columns on the excel spreadsheet as I'm adding it to an existing inventory spreadsheet which cannot be changed and has many more columns of information than I collect in my Word form.

I can make my form a table, with the same heading names as the columns in Excel if there is a benefit to do so.

Is there a way to take the info in the first field (Name), currently placed in Column A when the macro runs and direct it to Column C for example?

If I know how to do that I could modify the code accordingly.

Many thanks for your time and support!

(Sorry for duplicate post - my first time in a forum)

Yes, that could be done. You should start a new thread clearly setting out your requirements. This should include details about where the Model and Serial Number can be found and what other details - and from where - you need to extract.

Cross-posted at: https://social.technet.microsoft.com...013?forum=word
Please read the Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html