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

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.

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.

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

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

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:

Please link to S:\Online_School\zz_development\2014_Spring\Custom Media\First Drop\B230c_ma_MO_Done\Module_01_MO_Done\publish\web

With the < and > around it (won't show up if I add it above)

Ya got me.

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

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.