Technical Aspects By Satyanarayana Chinta
Saturday, October 5, 2013
Excel Macro to extract data from Website
Following is the code snippet:
With ActiveSheet.QueryTables.Add(Connection:="URL;website", Destination:=Range("$A$1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment