View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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/