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.
thanksSub 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
hari
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks