Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some code, I think developed for Excel 97 that requires a reference to
MS Internet Explorer. The problem is, I don't have a library for IE. Has it been changed? Can I download it from somewhere? OR, better still, can someone update the following code for XP? Sub FindImages(sURL As String) Dim oDoc As New MSHTML.HTMLDocument Dim IE As New InternetExplorer Dim i As Integer IE.navigate sURL Do While IE.readyState < READYSTATE_COMPLETE Loop Set oDoc = IE.Document For i = 1 To oDoc.images.Length If oDoc.images(i - 1).src Like "http://ichart.yahoo.com/*" Then saveImg oDoc.images(i - 1).src, ThisWorkbook.Path & "\temp.png" End If Next i Set oDoc = Nothing Set IE = Nothing End Sub Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return worksheet name containing value found in 3D reference funct | Excel Worksheet Functions | |||
Reference Cell if Found in a IF function | Excel Worksheet Functions | |||
IF NOT FOUND | Excel Worksheet Functions | |||
I found reference to info that I need on Excel-how do I acess the | Charts and Charting in Excel | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) |