Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |