hariimmadi
New Member
- Joined
- Dec 13, 2009
- Messages
- 6
Hi,
I use following code for many web links and works fine. But, for following web address, same is not importing entire webpage.
this weblink has a table with data but code is importing everything except the table. Could someone help me what the issue is with this code to extract table entries also.
thanks,
hari
I use following code for many web links and works fine. But, for following web address, same is not importing entire webpage.
this weblink has a table with data but code is importing everything except the table. Could someone help me what the issue is with this code to extract table entries also.
Code:
Sub test_get()
Set test = Sheets("Sheet2")
On Error Resume Next
test.UsedRange.Clear
test.Select
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.fxstreet.com/fundamental/economic-calendar/" _
, Destination:=Range("A1"))
.Name = "PagePopup.aspx?PageId=3270"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
thanks,
hari