Get Hidden fields of an html form on the web

[William Lipp]

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

 

[William Lipp]

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