'Web query switch toggle and import data
I need import "Annual" Report in this page(https://www.investing.com/equities/adv-micro-device-income-statement) but need to switch the toggle "Quarterly" to "Annual", if never switch it will import Quarterly report, how to write macro Quarterly switch to annual after import below data? please help
Sub Basic_Web_Query()
With Sheet3.QueryTables.Add(Connection:= _
"URL;https://www.investing.com/equities/adv-micro-device-income-statement", Destination:=Sheet3.Range("$A$2"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "2,3,4"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

