Pass cell value variables to web query via VBAExcel Help for Pass cell value variables to web query via VBA in Automating Data Analysis Tasks |
|
|||||
|
|
||||||||||
|
||||||||||
| Forum Topic | Login |
| 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 | ||
| [View the Full Thread for the "Automating a web query" Topic] |
| Find relevant Excel templates and add-ins for Pass cell value variables to web query via VBA in the Excel Business Solutions Directory |
| Find
Excel templates and add-ins in the Excel Business Solutions Directory |