Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to reveal formatting | Excel Discussion (Misc queries) | |||
How do I reveal hyperlinks in Excel? | Excel Discussion (Misc queries) | |||
How to reveal conditional formatting? | Excel Worksheet Functions | |||
Open Office Kills my secrets ! | Excel Programming |