Export Word .header Bookmark into Excel VBA Userform textbox.
Hi,
I am trying to populate some word properties into Excel VBA UserForm.
1. One is for Word PageCount, which i could solve with the aide of this site and it is working fine.
2. Second is Word .header.Bookmark which I want to transfer from Word to Excel VBA UserForm, textbox. This I couldn't make it. Did not get any online help for this so far. I need this from word only because we have multiple documents open and from one document we should transfer that part. I am not supposed to get it from excel.
Code for the 1st one
Sub M_snb()
GetObject(, "Excel.application").Run "Thisworkbook.M_snb", ThisDocument.BuiltInDocumentProperties(14)
End Sub
This was very helpful.
I am almost done with my project except for this below mentioned problem which I am not able to solve.
Is there any code for the Word Header Bookmark to get transferred into Excel UserForm textbox, which would complete my Excel UserForm and gets into sheet.
Thanks a lot for all the help I got from this site and thanks in advance for the above.
Please help me.