Check Out this page http://www.automateanalytics.com/2009/08/excel-functions-for-fetching-data.html or read the following >>>>>

Problems caused by proxy servers

Some people have also had problems using the functions with a proxy server. To get the functions working, the easiest way is to disable the proxy from Windows Control Panel: Internet Options: Connections: LAN Settings: uncheck "Use a proxy server". If you can't disable the proxy, you need to change the VBA code of the functions.
Before the line objhttp.Open "GET", URL, False you need to add objhttp.setProxy(proxySetting, varProxyServer, varBypassList)
After the line objhttp.Open "GET", URL, False you need to add objhttp.setProxyCredentials(username, password)
For instructions on how to set the parameters to those lines, see http://msdn.microsoft.com/en-us/library/ms760236(VS.85).aspx and http://msdn.microsoft.com/en-us/library/ms763680(VS.85).aspx

<<<<
I believe this would solve corporate proxy issues people are having (like me! :)

For a given keyword in Excel, it would be awesome to see the broad/exact search volume in Google.

-> Go to the Google Keyword Tool (https://adwords.google.be/o/Targeting/Explorer?__u=1000000000&__c=1000000000&ideaRequestType=KEYWORD_IDEAS) and retrieve monthly search volume for that given keyword (broad and exact).

User should be able to specify a language and country. To avoid filling in a Captcha, the SeoTools user should be able to add his Google Adwords data -> when logged in to the keyword tool with your Adwords account, you don't have to enter a captcha.

Also, when a logged-in user downloads data as a .csv, he gets to see more information, like the search volume for the previous 9 months, sorted by month. It would be absolutely amazing if this data could somehow be retrieved as well, so that we can make graphs in Excell and see how the search volume evoles for a given keyword...

Best regards and keep up the good work! I absolutely love your plugin!

My idea is to fetch YouTube information. This is useful because many companies put backlinks on videos. It’s also good for comparing competitor videos against each other.
Fetch metrics on YouTube Video or Channel:
video likes, video dislikes, video views, video comments (#), video favorites (#), video start date, channel video views, channel subscribers, channel latest activity date, channel date joined
Fetch text from YouTube video:
video category, video tags (keywords), video description (body text), extract URLS contained in video description, extract phone number(s) contained in description, video discovery referral links (URLS), audience gender and age, license, channel outbound URL(s),
The four most important metrics to fetch are ||Video Views|| Video Likes || Channel Subscribers || Channel Views ||
Example of Metric formulas could be:
=YouTubeVidLike() //Vid Likes
=YoutubeVidDislike() //Vid Dislikes
=YoutubeVidView() //Vid Views
=YoutubeVidComment() //Vid Comments
=YoutubeVidFav() //Vid Favs.
=YoutubeVidStart() //Vid Start Date
=YoutubeChanView() //Channel View
=YoutubeChanSub() //Channel Subscribers
=YoutubeChanLast() //Channel Last activity date
=YouTubeChanJoin() //Channel Join Date

Example of text based formulas could be:
=YoutubeVidCat() // Video Category
=YoutubeVidTags() //Video Tags
=YoutubeVidDesc() //Video Description
=YoutubeVidDescURL() //Video Description URLs
=YoutubeVidDescPhone() //Video Description Phone Number
=YoutubeVidRef() //Video Referring URLs (contained in “significant discovery events” on Show Video Statistics
=YoutubeVidAudience() //Video Audience Gender and Age
=YoutubeVidLicense() //Display video license (such as “Standard YouTube Licence”)
=YoutubeChanURL() //Channel outbound URLS (such as company page(s))