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




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/