I am trying to pull the data from websites. So I want to select 3 drop-down values in below URL but i cant change those values. example i want to select month ]CopyThat is:ie.document.querySelector("#fmonth1 option[value='1']")
CopyYou may need .Click on the end for selected. Can't test that url but also try:ie.document.querySelector("#fmonth1 option[value='1']").Selected = TrueCopyMore generally, if you know an element exists, and your syntax is correct, but you are still getting not set then it may be a timing issue where you need a longer wait (e.g. timed loop) before attempting to access, e.g.Const MAX_WAIT_SEC AsLong = 10Dim t AsDate, ele AsObject
t = Timer
Do
DoEvents
OnErrorResumeNextSet ele = ie.document.querySelector("#fmonth1")
OnErrorGoTo0If Timer - t > MAX_WAIT_SEC ThenExitDoLoopWhile ele IsNothingIfNot ele IsNothingThen
ele.Click 'may be needed to expose options
ie.document.querySelector("#fmonth1 option[value='1']").Selected = TrueEndIfCopy