Re 3: How is the code to recognize the table? VBA can find tables easily enough, but how would it know then it's found the correct table? And, given that there's more than one table in the document, are the data in every table, or just one/some?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi macropod,

I had a go at trying to record a macro to see how it goes. Luckily for me, the data will be in a template word document with several tables. The exact "location" of the data that I need is always in the same cell for all documents. I was thinking to simply move the cursor to the specific location and select everything in the cell, paste it into excel. This is just what I thought and I think it is very very crude. Perhaps you have a better idea? Please let me know what you think.

Thank you.