Automating a web query

Excel Help for Automating A Web Query in Automating Data Analysis Tasks

Automating A Web Query

Rate this: (3/5 from 1 vote)

	Hello, I am by no means an expert at using VBA in fact I just started using it recently.  I am wondering if there is any way to have a web query reference a links that are on my worksheet. I am looking up tax information for property and each property has a link in a cell next to the address for the tax info.  Lets call that cell with the link D1. All of the properties are listed one after the other going down in rows and the corresponding links are in the D column.  Is there any way to have my web query reference the corresponding links in the D column?  Thank you.
	Posted by Double A Enterprises on 16 Jul 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Pass cell value variables to web query via VBA Rate this: (3/5 from 1 vote) We queries can be run using VBA code by looping through the cell values that are required to extract the data. I suggest that you look at the post here which gives an example of doing this and includes a downloadable workbook to use, test and modify. The example includes a small sub routine to make the web query from the populated cells in one of the sheets.
	Excel Business Forums Administrator
	Posted by Excel Helper on 16 Jul 2010

Displaying page 1 of 1