Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Hidden fields of an html form on the web
I need to access a page on the web that has a form with hidden fields,
and get the values of the hidden fields. I know how to retrieve web pages using querytable and use macros to process the page to find things like stock quotes. That doesn't work here because the hidden fields don't affect the display (they are in the form to be sent back when the user submits the form). I see that recent versions of Excel have some querytable settings I haven't used - do any of these accomplish what I need? I once saw somebody post about retrieving the html page as text - I could then parse the string to find the hidden fields. How would I grab the html as text? William |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Hidden fields of an html form on the web
On Fri, 19 Nov 2004 09:48:39 -0500, William Lipp
wrote: I need to access a page on the web that has a form with hidden fields, and get the values of the hidden fields. EUREKA! Setting the connection string to "TEXT;http://ElevenSmooth.com" instead of "URL;http://ElevenSmooth.com" does the trick! William |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet and Exclude Hidden fields | Excel Worksheet Functions | |||
Deleting HTML form objects? | Excel Discussion (Misc queries) | |||
GetPivotData for hidden fields | Excel Discussion (Misc queries) | |||
removing hidden fields from equation? | Excel Discussion (Misc queries) |