8/25/2023 0 Comments Autoclick using vb'As long as the file can be opened, I should be able to complete the data extraction with my own codes. 'Here I would like to open the file in excel, but I am stuck at the "save as" pop up. Set TargetFile = ie.document.getElementById("ctl00_gvMain_ctl02_hlTitle") Set SearchButton = ie.document.querySelector("") Set SearchBox = ie.document.getElementById("ctl00_txt_stock_code") While ie.Busy Or ie.readyState < 4: DoEvents: Wend Set ie = CreateObject("InternetExplorer.Application") Is there any ways to do that? Thanks!Ĭodes that I have at present: Option Explicitĭim SearchString As String, SearchBox As Object, SearchButton As Object, ie As Object I have another question concerning the next step: I would always like to click the first link that appears after clicking the search button, and open the file in order to extract certain data. Thanks to Qharr, I have successfully performed auto search on the website.(My previous question:Įxcel VBA: Cannot perform auto search on website)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |