Thanks for reply macropod.

I need only one document that i have processed and that information loaded in Excel UserForm because we have two people's interview taken in one claim with one single claim number, and both their conversations are keyed in two different documents, so both documents are open for reference to each other. The Claim Number remains same for both the paties but there will be 2 entries in the excel for two times with same Claim Number but different names. We are making mistakes while putting the names in the Excel manually. So, i got a thought of automation and I learned VBA through this sites and created a UserForm in Excel. There are some other details which gets populated through Vlookup from a different Excel Sheet and the above mentioned details should come from Word document to make a complete UserForm. Then the UserForm details goes into the sheet. For that reason I need to get the Word Header Bookmark part which is the claiming person's name to get into Excel UserForm and this macro should, at any cost, run from word only. We are having escalations from client also.

I am able to get the page count with M_snb () code.

* I need the code for the Word header bookmark to get transferred into Excel UserForm.
* Code for (INAUDIBLE-L) and (INAUDIBLE-A). I am done with my automation. Please help me with regards to this.

Thanks in advance.