Grab Data From Word Header using Excel Macro

[WvuSoldier]

I've been working for days on this code, to no avail...

I have about 800 word files with headers that looks like so:

Please Login or Register  to view this content.

And I'm attempting to bring them into Excel into their own columns.

So far I'm getting all sorts of errors doing this:

Please Login or Register  to view this content.

This most recent version was attempted by doing the macro in Word first, then bringing it over to Excel with the Word.Application (or Obj_Wapp) function.

I'm sure there's an easier, and functional, way to do this..Any thoughts?

[Leith Ross]

Hello WvuSoldier,

Welcome to the Forum!

You should include a sample Word file.

[WvuSoldier]

Thanks for the heads up. Here's a copy of the word document template I am trying to pull the header data from.

Here's a complete copy of the code as I have it so far...

Please Login or Register  to view this content.

Thanks again guys!

[WvuSoldier]

For the Visually inclined, here is what the end product looks like. I am hung up on getting the HEADER data from the above-attached word file into excel in a way that the data can be placed in the respective columns

[WvuSoldier]

Attachements didn't follow. Attached is the sample Word Document and a .JPEG of what the final product looks like (minus the Header Data, which is the crux of my issue)

Respectfully,
WvuSoldier

[Kenneth Hobson]

Please Login or Register  to view this content.

[snb]

Basically this is all you need:

Please Login or Register  to view this content.