Object Variable Or With Block Variable Not Set Getelementsbyname Vba

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

---

If inside of a parent iframe/frame you will need to navigate that first e.g.ie.document.getElementsByTagName("iframe")(0).contentDocument.querySelector("#fmonth1 option[value='1']").Selected = TrueCopy

---

I tested the following now I can access the page:Public Sub MakeSelection() Dim ie AsNew InternetExplorer With ie .Visible = True .navigate "https://www.bseindia.com/markets/debt/BhavCopyDebt.aspx?expandable=6"While .Busy Or .readyState < 4: DoEvents: Wend .document.getElementsByTagName("iframe")(0).contentDocument.querySelector("#fmonth1 option[value='1']").Selected = True Stop '<==Delete me later .Quit End With End Sub Copy Share Post a Comment for "Object Variable Or With Block Variable Not Set Getelementsbyname Vba" Top Question Right Floated Element Disappears When Using Columns In Firefox I am using an ol element with column-count and column-gap p… Remove The Button Inside The Dropdownlist Is there a way to hide or remove the arrow button inside a … Adding Asterisk To Placeholder, Or A Nice Way To Mark Required Fields Via Placeholder I'm looking for a way to style the asterisk in the plac… Mystery Margin Or Padding On List I cannot figure out where the padding is coming from the on… Homepage Slow To Load When I go to the homepage of my website after clearing my c… How To Add Placeholder Field?

I've been trying to add placeholder in input type='…