downloading charts from internet URLs using Excel VBA
 

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/

downloading charts from internet URLs using Excel VBA
 

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/