VBA Sentiment Analysis using XMLHttp

[sonyaelis]

I'm supposed to taking a column of 1000 cells of text snippets, text files (sourcePaths), and URLs and then doing sentiment analysis on them all by sending HTTP requests to this website: "http://sentistrength.wlv.ac.uk/#Test" and then retrieving the sentiment analysis results for each cell. I have created both a GetURLText and GetTextFile subroutine that import the data from websites and textfile source paths (respectively), and have created another subroutine that implements these and "attempts" to communicate with the website. I'm so lost now though! I'm not sure what I'm doing wrong and what I can change. Will take any help!

Snippets are in cells B10:B100. I still haven't figured out how to loop through the output columns (with the results from the sentiment analysis)

Please Login or Register  to view this content.

What I am getting in return instead of the sentiment analysis results is ALL of the HTML code behind the main page of the website? I don't understand...