Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,814
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 1 November 29th 05 01:44 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? jocke Excel Discussion (Misc queries) 0 November 28th 05 06:37 PM
Edit Query from Excel will not open query in MSQuery Michelle Excel Programming 0 February 21st 05 03:59 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"