Description of every module: General information for the website: Web/Development Software Job - not for any website in particular
Description of every page/module: I need someone to create an excel spreadsheet that does the following things:
Description of requirements/functionality: Specifications
1. perform keyword searches on Google
2. to find keywords in close proximity to each other in text of article
3. to scrape that entire sentence onto spreadsheet
4. to rinse and repeat the top 5 - 10 results so that the user can quickly see data similarities/differences.
Description of requirements/features: Top of spreadsheet will contain the search box where keywords e.g. "definition" can be typed in plus a search button to start the search
Column A will contain all keywords that the search term needs to be combined with e.g.
Column A: Row 1 - Car; Row 2 - Career, Row 3 - Construction
When typing in the keyword 'definition" (This would request that the top 10 results where those 2 keywords appears in the same sentence is scraped back to columns 2 - 11 of spreadsheet.)
And so on.
Allow for at least 100 - 500 Rows of keywords to be combined with a search word such as definition, expert, date of birth, death, etc.
Extra notes: I am specifically looking for VBA as this is faster than an online app. Do not provide a different solution to VBA.
Susie B.99% (42)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Thank you for inviting me to bid for the projet. I have created a pilot model for the same on my local system. There is a problem you are going to face. After certain hits, google will recognize the IP and will block it. I tried it using proxy IP too but after 20 hits, it got blocked too. I would suggest you to not to go for this solution. Even if someone comes up with a tweak around, it would not be a permanent solution. Rest, I leave it upto your wise wisdom and sorry if I have crossed my line and offended you.