Extract Data from Word, Send to Excel (please help?)

[Mike Lowe]

Ok, so the most tedious part of my job is that I have to take any sort of media linked in a document (documents are 100 pages+ each, at least 5 of them at a time) and place it into an Excel document for tracking purposes.

Every source listed within the Word document starts with a "<" so I can easily find them all, but the copying and pasting is absolutely dreadful.

Is there a way to tell Word, "grab everything that starts with a '<' and ends with a '>' and send it to Excel."?

I will worship at your feet if you can help me out with this lol.

[Sun Tzu]

I don't have any useful advice for you, other than to advise you and your company to stop living in the year 2001 and move on from MS Office.

[Mike Lowe]

Ha, no kidding! It's a terrible usage of the time they're paying me for.

[DaddyTorgo]

You mean of course aside from just doing a "Find" on " < " and then manually copy/pasting I assume?

[Mike Lowe]

Yeah, exactly. Half the battle is just getting those references into Excel. From there, labeling the rest as I need to do isn't a big issue (although that'd be great too if Excel could see "http" and label it "Article" or something like that).

A typical entry on the Word doc looks like this:

<table border="0" cellpadding="0" cellspacing="0" width="898"><colgroup><col width="898"></colgroup><tbody><tr height="20"> <td class="xl65" style="height:15.0pt;width:674pt" width="898" height="20">Please link to S:\Online_School\zz_development\2014_Spring\Custom Media\First Drop\B230c_ma_MO_Done\Module_01_MO_Done\publish\web</td> </tr></tbody></table>
With the < and > around it (won't show up if I add it above)

[DaddyTorgo]

Ya got me.

Presumably you've tried using the google to find an answser?

[Mike Lowe]

Yeah, I've seen some stuff but it seems to be more about straight lines of basic .rtf stuff...mine isn't that simple; I would need Excel to "grab" lines of text without me having to consolidate things into pretty pre-arranged lines for it as the documents are all over 100 pages and the links are things like additional reading content, videos, custom/interactive media pieces, etc. for students mixed into the online lectures.