Excel VBA - Lookup and fetch data from word table (is it possible?)

Hi,

I have a spreadsheet with a set of reference numbers and details that need to be fetched from different word files.

I then have a folder structure like this 'drive\"reference number"\document name' (The reference number is the name of the folder, this relates to the reference number in the spread sheet. The document name is within the folder named with the reference number and in all folders this document is named the same. This is a word document.)

Within this word document there is a table with just some select details i need to get into the excel spreadsheet.

Is this possible at all with or without VBA Scripts or any other ways you can think of? I have a feeling it is not but i am yet to have tried yet i just want to see if anyone on here knows if it is and how to do this.

I have only ever used VBA a couple of times so please bare with me.

Thanks.

Has anyone got any ideas?

Yes, it is possible but you need to provide specifics if you want a detailed answer.

It is simple enough to open a Word document and go to a table (but you need some way to define which table) and extract details, but again you need to give details.

The following example will open a Word doc and copy all the details from the first table to the active worksheet

Please Login or Register  to view this content.

The code requires a reference set to the Word Object model as it uses early binding (Something for you to look up).

Okay,

So here are the files. The word document and the spreadsheet. I couldn't get the macro to run without showing me an error. I really are not that experienced with VBA.

So this is the word document - https://drive.google.com/open?id=0B4...lJwelJzX1pQQzA

This is the spreadsheet - https://drive.google.com/open?id=0B4...0dYWTkyREotZEE

These word documents are all kept in separate folders that are named the reference number followed by the date. Such as 105350714 so it will need to look up the folder within a directory ignoring the last 4 digits.

Thanks.

Originally Posted by Harveyl12

I couldn't get the macro to run without showing me an error

What error?

Compile Error
User defined type not defined.

But i cant see where i need to define anything

... uses early binding (Something for you to look up)

Did you do that...?

Hi,

I will research this. Is there anything in particular i need to look at with the early bindings?
Where is this in the code?