How to get Google Page Rank and Number of Searches in Excel Worksheet?
If I am interpreting your question correctly, one of the tasks you need to accomplish is
How can I programmatically assign google page rank to a list of urls?
You can find the code for this in this CodeProject article: Google Pagerank Programmatic Request
As for the Excel part: it depends on what programming framework or platform you might be using. You can use to create a .NET extension for Excel using Microsoft Visual Studio Tools for Office.
source to share
You have two options, both of which are unfortunately poorly documented.
If you're comfortable with C / C ++, you can write a special DLL called "XLL" that you can call at runtime Excel. There are some rare documentation . Please note that this is not very convenient to use.
If you prefer .NET, there is a binding for the entire Office suite outlined here that allows you to write COM methods that you can call from Office. It's meant to be automated, but you can write any managed code you want and invoke an Excel query into it.
There is also what Remu just suggested; I don't actually have a copy of Excel to test this, but this might be the easiest option.
source to share
By link, I meant keywords, not URL. I want to put a keyword in one cell and pull the number of searches and page rankings in adjacent cells.
I tried to do the same with a web query in excel, but I can only achieve the number of search queries. this is also not in the correct cell (trying to figure out). But I have no idea how to get the pages.
I'm not tech savvy enough to code a binder or plugin for myself. Though I check the splattne link. Please focus more on this. It will take a long time if I try to do this.?
Thinkjayant relationship
source to share