Import Header from a Word doc to excel

[arryb]

I am currently importing an rtf file to excel from word using the copy all and paste option. This is fine except for the fact the the Header is not copied. I need to be able to grab certain text from the header to declare as a string within my excel spreadsheet.

In there an easy way to automate this procedure using VBA.

All help appreciated.

Thanks

Arry

 

[SkipVought]

arryb,

I am not a Word VBA guru, but here's some code that might get you started...

    For Each s In ActiveDocument.Sections
        For Each hd In s.Headers
            MsgBox hd.Range.Text
        Next
    Next

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[arryb]

I will give it a try.

Cheers