ShawnExcel
Member
I ran in to a tough project and am looking for some suggestions/help on where to start.
I have text (500+ words) that I need to categorize and count. Sample text is in the word document. The Excel (output.xlsx) doc includes two tabs.
Tab 1 - The category headers (word types, such as adverb or pronoun) with a list of the relevant words below
Tab 2 - Desired output, including analysis of the document (total words, words per sentence) and a count of the number of words in each category. I don't want to know how many times "Fox" was used but I want to know how many total "Animal" words were used.
Any suggestions, or is anyone able to help me with some initial code that I can play with. It's been around a year since I've touched VBA - I used to be decent but I'm at a loss on where to start with this.
Alternatively, if there's any really good software besides Excel/VBA that could do this, I can try to learn that, just let me know.
I have text (500+ words) that I need to categorize and count. Sample text is in the word document. The Excel (output.xlsx) doc includes two tabs.
Tab 1 - The category headers (word types, such as adverb or pronoun) with a list of the relevant words below
Tab 2 - Desired output, including analysis of the document (total words, words per sentence) and a count of the number of words in each category. I don't want to know how many times "Fox" was used but I want to know how many total "Animal" words were used.
Any suggestions, or is anyone able to help me with some initial code that I can play with. It's been around a year since I've touched VBA - I used to be decent but I'm at a loss on where to start with this.
Alternatively, if there's any really good software besides Excel/VBA that could do this, I can try to learn that, just let me know.