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.