Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Okay, I'm needing to do this same thing again, but can't figure out where the
item/innertext I need is: The webpage is: http://www.gocomics.com/calvinandhobbes/2010/01/16 ....and what I need is the image (on this particular page it's): http://imgsrv.gocomics.com/dim/?fh=8...8010a8&w=900.0 thanks, SouthernAtHeart "Joel" wrote: You don't need to get the source. You can use the IE explorer like below to help you filter the data. The source is under the IE.Document.all property. You can get these lines by doing a loop like this for each itm in IE.Document 'your code here next itm You can use the methods getElementsByTagname(), and getElementById() to help you filter the data. I often for debuggin use something like this RowCount = 1 for each itm in IE.Document Range("A" & RowCount) = itm.tagname Range("B" & RowCount) = itm.Classname Range("C" & RowCount) = itm.id Range("D" & RowCount) = left(itm.innertext,1024) RowCount = rowcount + 1 next itm The source is partioned into items. Has you go down the ALL property the innertext is partioned into small pices. When you do the dump above you will see the same innertext repeated over and over again but broken into samller pieces each time it is repeated. If you need more help give me the URL and I will get what you need. I help lots of people who have had problems. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving data to a webpage | New Users to Excel | |||
getting data from website's url and webpage | Excel Programming | |||
Importing webpage data into Excel | Excel Discussion (Misc queries) | |||
Get Webpage data as text using VBA w/o Webquery | Excel Programming | |||
data from external webpage | Excel Programming |