ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Web Query (https://www.excelbanter.com/excel-programming/437592-excel-web-query.html)

Steve

Excel Web Query
 
Hello,

I would like to perform a web query that pulls data from an online page and
enters it into excel. I know the basics for creating web queries and also
know how to pass parameters with the web queries (when I know the parameter
names). The problem arises when I do not know the parameter names for the
textboxes, for which I want to to retrieve data...specifically I want to
retrieve data from http://www.msha.gov/drs/drshome.htm. ; I have a specific
MSHA Mine ID for which I would like to be automatically entered and then
directed to the next page - how can this be done? Any thoughts.


Don Guillett

Excel Web Query
 
Maybe if you provide a couple of ID numbers and/or names it would help??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
Hello,

I would like to perform a web query that pulls data from an online page
and
enters it into excel. I know the basics for creating web queries and also
know how to pass parameters with the web queries (when I know the
parameter
names). The problem arises when I do not know the parameter names for the
textboxes, for which I want to to retrieve data...specifically I want to
retrieve data from
http://www.msha.gov/drs/drshome.htm. ; I have a
specific
MSHA Mine ID for which I would like to be automatically entered and then
directed to the next page - how can this be done? Any thoughts.




All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com