Web page will not reveal its secrets
 

I'm trying to suck the data off of a web page, however they've managed
to hide the data such that it doesn't appear even if you "view
source". The data is there when you view the page normally, and in
fact you can even select and copy it. However, when trying to grab it
by looking through what comes down the pike, it's just not there. How
does one get the data off a site like that?

VBA 6 & Excel 2000

Thank you

Web page will not reveal its secrets
 

What does "looking what comes down the pike" involve?

Google for "IE automation": that should allow you to access the rendered
Document.
Not possible to say anything more specific without a URL.

Tim

"Dudely" wrote in message
...
I'm trying to suck the data off of a web page, however they've managed
to hide the data such that it doesn't appear even if you "view
source". The data is there when you view the page normally, and in
fact you can even select and copy it. However, when trying to grab it
by looking through what comes down the pike, it's just not there. How
does one get the data off a site like that?

VBA 6 & Excel 2000

Thank you

Web page will not reveal its secrets
 

Url and detail

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dudely" wrote in message
...
I'm trying to suck the data off of a web page, however they've managed
to hide the data such that it doesn't appear even if you "view
source". The data is there when you view the page normally, and in
fact you can even select and copy it. However, when trying to grab it
by looking through what comes down the pike, it's just not there. How
does one get the data off a site like that?

VBA 6 & Excel 2000

Thank you

Web page will not reveal its secrets
 

On Jun 12, 7:33*pm, Dudely wrote:
I'm trying to suck the data off of a web page, however they've managed
to hide the data such that it doesn't appear even if you "view
source". *The data is there when you view the page normally, and in
fact you can even select and copy it. *However, when trying to grab it
by looking through what comes down the pike, it's just not there. *How
does one get the data off a site like that?

VBA 6 & Excel 2000

Thank you

I think I figured it out. If I run into the problem again, I'll be
back. Thank you for the responses and sorry for the trouble.