downloading charts from internet URLs using Excel VBA

[rm24746]

For years I have been using Excel VBA to automate getting information
from internets sites. The following code will obtain TEXT, but not
objects such as a chart. Does anyone know a simple method to download
a chart?

With
Sheet1.QueryTables.Add(Connection:="URL;http://www.pcquote.com/stocks/QuoteDirect.php?ticker="MSFT"l,
Destination:=Sheet1.Range("A1"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.RefreshOnFileOpen = False
.BackgroundQuery = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.Refresh BackgroundQuery:=False
End With

Wayne Andre
(e-mail address removed)

 

[Tim Williams]

fix to suit...

http://groups.google.com/groups?hl=...=#v9sH6A#[email protected]&rnum=5

tim