Sometimes Excel’s native Web Query isn’t robust enough to handle advanced web queries with query parameters, multiple queries, etc…
In the following post, Nathan Oliver provides an example of working around these limitations via automation, interfacing Excel with Internet Explorer:
http://www.mrexcel.com/board2/viewtopic.php?p=884522#884522
And in the following post, Nathan explains his process for developing such a procedure, which he uses, over and over again, on differing, advanced web queries:
http://www.mrexcel.com/board2/viewtopic.php?p=884135#884135
Kudos, Nathan; the coveted koozie is yours.
In the following post, Nathan Oliver provides an example of working around these limitations via automation, interfacing Excel with Internet Explorer:
http://www.mrexcel.com/board2/viewtopic.php?p=884522#884522
And in the following post, Nathan explains his process for developing such a procedure, which he uses, over and over again, on differing, advanced web queries:
http://www.mrexcel.com/board2/viewtopic.php?p=884135#884135
Kudos, Nathan; the coveted koozie is yours.