Details for sivuddusivuddu has participated in the following threads:
Added by sivuddu on 22 May 2021 at 17:21
I am able execute code written by WiseOwl, but i am trying execute code for site - https://fedai.org.in even i am unable to find elements by id or by name etc...
Tab "Rates" > Report as under
Lates 2 excel reports to be extracted
Need to create folder and report name as Revaluation Rates with respective date.
getting error at object variable or withblock variable not set at HTMLButtons(0).Click because need to close pop-up screen and then need to extract the files
Dim IE As New SHDocVw.InternetExplorer
Dim XetraHTMLDoc As MSHTML.HTMLDocument
Dim HTMLButtons As MSHTML.IHTMLElementCollection
Dim HTMLInput As MSHTML.IHTMLElement
IE.Visible = True
Do While IE.ReadyState <> READYSTATE_COMPLETE Or IE.Busy 'Wait until site is ready
Set XetraHTMLDoc = IE.Document
Set HTMLButtons = XetraHTMLDoc.getElementsByTagName("button")