Customize an Excel Function

IN PROGRESS
Bids
17
Avg Bid (USD)
$94
Project Budget (USD)
$30 - $250

Project Description:
I have attached an Excel visual basic script that has 95% of the functionality I am seeking.

Attached is an Excel spreadsheet (SERP Rankings.xls) - the script can be viewed in Excel's Visual Basic editor. If you open it you can see that it queries a specified website for a set of keywords and returns a numerical result based on the website's ranking for that keyword on Google.

What I would like is a modification of this script to create a custom function (i.e. =findrank) to work with the second attached spreadsheet (sample.xls). Column A is a URL and Column B is a Keyword. The function should take both of these inputs and return a numerical rank based on Google's search engine results.
...

So the custom function would be something like =findrank(URL,keyword) and would automatically return a dynamic result based on Google's search engine result listings. I am unable to code in Visual Basic but it appears from the functionality of the attached script that this should be very easy to modify.

Some notes:
-The attached script is defaulted to check Google's first 30 results. I'd like this to be customizable.
-The attached script is defaulted to check google.com - I'd like this to be customizable to other Google engines (i.e.: Google.ca, Google.co.uk, etc.)

Please email me with any questions, suggestions or comments.

Thanks,
Daniel

Skills required:
Excel, PHP, Software Architecture, Visual Basic
Additional Files: FindRank+Script.zip
Hire danielrobinson
Project posted by:
danielrobinson Canada
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 70
in 1 days
Hire sameg
$ 100
in 3 days
Hire fcbarnard
$ 80
in 3 days
Hire dhs100
$ 100
in 0 days
Hire justTry
$ 50
in 0 days
$ 70
in 2 days
Hire unimaxtech
$ 50
in 3 days
Hire guessor
$ 50
in 3 days
Hire amack
$ 70
in 2 days
Hire perissf
$ 180
in 1 days