leftorama.blogg.se

• #Microsoft edge vs ie logo how to#

The following is quoted from the links above: With Webdriver you have two initial non-mutually exclusive options: Although there is good content in the comments against this question: /questions/54814411/edge-browser-automation, there is no answer given. Webdriver I believe is the way forward with Edge. Set elements = Html.getElementsB圜lassName(Sheets("Sheet10").Range("C2")) ' parent CLASS ObjIE.navigate Sheets("Sheet10").Range("F2").Value & Replace(Worksheets("Sheet10").Range("G2") & Range("H2").Value, " ", "+")ĭo While objIE.Busy = True Or objIE.readyState 4: DoEvents: Loop '''wait here a few seconds while the browser is busy ''' Url to NAVIGATE is taken from sheet10 as is the number of pages Set objIE = New InternetExplorer 'initiating a new instance of Internet Explorer and asigning it to objIE Dim Html As HTMLDocumentĭim Y As Integer '''integer variable we'll use as a counterĭim result As String ''''string variable that will hold our result linkĭim pageNumber As Long ''' Number of pages.ĭim nextPageElement As Object '''page elementĭim m圜ounter As Long '''counting the number of loops data goes to sheet10 q2 PS I will be sending the worksheet out to other users so it needs to be able to work on their PC and not just mine. I have tried to google the answer, however it mentions Shells and I am not to sure how I would write a code for that. Ideally i would have liked it to use Edge or IE, check which is installed on PC and use that one. However MS Edge is updated to all window PC

Not everyone will have Chrome or Firefox installed so I have not gone with them. The rest of the code is fine the only bit I need to change is to use another web browser.

#Microsoft edge vs ie logo how to#

I now want to update this bit of my code to use Windows Edge, however I am unsure how to do it. I currently use IE to do some web scraping, as you may be aware IE support will be coming to an end in September 2021.