Home > Forum Home > Analyzing Corporate Financial Data > Business Data, Analysis and Niche Generation > Use a web query Share

Use a web query

Excel Help for Use A Web Query in Analyzing Corporate Financial Data

Forum TopicLogin

Use A Web Query

Rate this:
(3/5 from 1 vote)
FedupThe site simply uses Google and Yahoo APIs to return business information based on key words and location.

To scrape the results to Excel, you can use a web query.  Construct the URL and pass it to a web query.  For excample the URL structure for the key words "Microsoft Excel" in New York is http://findabusiness.org/search.php?business=microsoft+excel&location=new+york.

To load the web query with the key words and location from Excel cells as well as extracting a section of the page, record a macro when running the web query and modify accordingly along the same lines as the VBA in this post.

 Excel Business Forums Administrator
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for Use a web query in the