Home > Forum Home > Automating Data Analysis Tasks > Automating a web query > Pass cell value variables to web query via VBA Share

Pass cell value variables to web query via VBA

Excel Help for Pass Cell Value Variables To Web Query Via Vba in Automating Data Analysis Tasks


Forum TopicLogin

Pass Cell Value Variables To Web Query Via Vba

Rate this:
(3/5 from 1 vote)
HappyWe 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Pass cell value variables to web query via VBA in the