Is it possible..

[BrandonWLH]

To read in a Word, PowerPoint, Excel or PDF into Excel for the purpose of word counting?

Here is what I'm trying to accomplish. Our server has over 70k files on it, NONE of them have keywords added to them so searching is a nightmare. I've been tasked with coming up with a way to get the server search friendly and my idea was to use Excel to read in these file types, count how many times certain keywords appear, then take the top 5 keywords and add them to the file. Not perfect, but no one is going to keyword 70k files by hand. Its over 1200 man hours of work if you assume 1 minute per file to read through it and pick the keywords.

Putting the keywords onto a file use VBA/Excel I've already solved, its the word counting I haven't yet. I didnt want to spin my wheels for hours when what I'm trying to do may not even be possible.

Is there a way to read in those files mentioned above to do a word count?

 

[MrKowz]

It depends. You mentioned "looking in files", but you also mentioned that you already have the keywords in an Excel file. Is all the data you need to work with currently stored in Excel, and you just need to count how many times each of those words show up?

 

[BrandonWLH]

Sorry, what I meant is that I already have code written which allows me to extract, change and reapply keywords through VBA from an Excel sheet.

No data is in the Excel sheet.

I need to write code to automate looking in/opening 70k files, search for a list of 50 words and get the count of those word occurances then apply the top 5 words occurances.

The only thing I'm not sure of is how to get .doc, .ppt, .pdf, etc files into excel so I can do a word count. I know there are functions that allow you to open atleast a Word doc or a PowerPoint in there, but I need to extract the text from those files so i can search through it.

 

[MrKowz]

I see. That, unfortunately, is beyond my knowledge (working cross-platform). Hopefully someone here can be of assistance (I've seen some crazy solutions, so it is a possibility).

Best of luck!

 

[BrandonWLH]

Le bump. I don't need anyone to do this for me, just is it even possible and just point me where to start.