Hi macropod,

Thank you for your reply. Luckily, the position of the information that I need in the cell is always the same.

I think there is a way to open Words using macro in Excel. However, (i)once in Words, I am not sure how do I ask Words to copy the data and pass back to Excel. (ii)Also, I am not sure how to automate that so that it does that to all the files in a specific folders (I have gathered all the required document in the same folder).

Thank you.