VBA Excel Developer Needed
- or -
Post a project like this2363
$$
- Posted:
- Proposals: 3
- Remote
- #1739610
- Awarded
Description
Experience Level: Intermediate
General information for the business: Marketing Company
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:
Extra notes: I am specifically looking for VBA as this is faster than an online app. Do not provide a different solution to VBA.
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:
Extra notes: I am specifically looking for VBA as this is faster than an online app. Do not provide a different solution to VBA.
Trackerlead
99% (73)Projects Completed
61
Freelancers worked with
55
Projects awarded
34%
Last project
31 Mar 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
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.
517090
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies