fix to suit...
http://groups.google.com/groups?hl=e...phx.gbl&rnum=5
tim
"rm24746" wrote in message
...
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/QuoteD
irect.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/