Write a macro/Script
- or -
Post a project like this$$
- Posted:
- Proposals: 3
- Remote
- #960550
- Expired
Description
Experience Level: Intermediate
General information for the business: N/A
Description of requirements/functionality: I have an excel sheet for which I need a simple macro/script written to automate a verification process. The excel sheet is attached for your reference.
Here's what the macro/script should do:
1. Read value/text from 'Account' + 'Address1' + 'City' + 'State' + 'ZipCode' fields.
2. Combine value/text and search it in Google. For example, for first record the macro/script should combine the value like - THE SPORTS AUTHORITY, INC., 1512 S KOELLER RD., OSKOSH, WI, 54903. As you can see that I have put comma (,) after each text/value so the script should also combine the value/text and include a comma in between (except the last value/text).
3. Now, if Google displays a result then the macro/script should take the URL of the first displayed result and put it under the URL field and then put a text 'Address Verified' under 'Status' field.
4. In addition, the macro/script should search for text in 'Account' field in the entire URL of the first displayed result and if it is TRUE then the script/macro should put that URL under the 'Website' field. For example See row no. 17. Here you will find that the URL contains 'thebay' which is also the text under the 'Account' field.
5. In case the search does not display any result then the whole row is to be marked RED and 'Address could not be verified' is to be put under the 'Status field'.
6. This process is to be repeated unless every record/row is verified.
Also, the script/macro should run on any similar excel sheet. A brief write-up of how to run the script/macro on another excel sheet would be needed.
A better approach (if any) would be much appreciated.
Specific technologies required: Excel, VBA, Excel Macro, PHP Script
Extra notes:
Description of requirements/functionality: I have an excel sheet for which I need a simple macro/script written to automate a verification process. The excel sheet is attached for your reference.
Here's what the macro/script should do:
1. Read value/text from 'Account' + 'Address1' + 'City' + 'State' + 'ZipCode' fields.
2. Combine value/text and search it in Google. For example, for first record the macro/script should combine the value like - THE SPORTS AUTHORITY, INC., 1512 S KOELLER RD., OSKOSH, WI, 54903. As you can see that I have put comma (,) after each text/value so the script should also combine the value/text and include a comma in between (except the last value/text).
3. Now, if Google displays a result then the macro/script should take the URL of the first displayed result and put it under the URL field and then put a text 'Address Verified' under 'Status' field.
4. In addition, the macro/script should search for text in 'Account' field in the entire URL of the first displayed result and if it is TRUE then the script/macro should put that URL under the 'Website' field. For example See row no. 17. Here you will find that the URL contains 'thebay' which is also the text under the 'Account' field.
5. In case the search does not display any result then the whole row is to be marked RED and 'Address could not be verified' is to be put under the 'Status field'.
6. This process is to be repeated unless every record/row is verified.
Also, the script/macro should run on any similar excel sheet. A brief write-up of how to run the script/macro on another excel sheet would be needed.
A better approach (if any) would be much appreciated.
Specific technologies required: Excel, VBA, Excel Macro, PHP Script
Extra notes:
Bitrixa L.
100% (8)Projects Completed
16
Freelancers worked with
13
Projects awarded
9%
Last project
15 Mar 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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