Click button in using VBA Chrome selenium

Question

Good night
I want to click the upload image button using chrome selenium
I've tried to code, but it doesn't work

Public Sub CallChrome1()
    Dim ch As Selenium.ChromeDriver
    Dim wsh As Object
    Dim strFolder As String
    
     Set wsh = CreateObject("Wscript.Shell")
    strFolder = wsh.regread("HKCU\Volatile Environment\LOCALAPPDATA") & "\Google\Chrome\User Data"
    Set ch = New Selenium.ChromeDriver
    
    ch.AddArgument ("user-data-dir=" & strFolder)
    ch.AddArgument ("profile-directory=Default")
    ch.Start
    ch.Get "https://sellercenter/apps/product/publish"
    Application.Wait (Now + TimeValue("0:00:05"))
    
    ch.ExecuteScript "window.open(arguments[0])", "https://sellercenter/apps/mediacenter"
    ch.SwitchToNextWindow
    Application.Wait (Now + TimeValue("0:00:10"))
    ch.FindElementByXPath("//a[@class='next-btn next-medium next-btn-primary' and text()='Upload Image']").Click
       MsgBox "Press OK to Close"
End Sub

this is the html code

<button type="button" class="next-btn next-medium next-btn-primary" role="button">Upload Image</button>

Would appreciate any advice on how to click this button using the Selenium in Excel VBA, thanks.

undetected Selenium · Answer 1 · 2021-12-05T23:02:18.900

0

By.CLASS_NAME accepts a single classname. So you can't pass multiple classnames with in FindElementByClass().

To click() on the element Upload Image you can use either of the following Locator Strategies:

Using FindElementByCss:

Application.Wait (Now + TimeValue("0:00:10"))
ch.FindElementByCss("a.next-btn.next-medium.next-btn-primary").Click

Using FindElementByXPath:

Application.Wait (Now + TimeValue("0:00:10"))     
ch.FindElementByXPath("//a[@class='next-btn next-medium next-btn-primary' and text()='Upload Image']").Click

edited Dec 05 '21 at 23:02

answered Dec 05 '21 at 14:04

undetected Selenium

183,867
41
278
352

Thank you I've tried all the code above, but it doesn't work – anggun Dec 05 '21 at 22:41
@anggun Checkout the updated answer and let me know the status. – undetected Selenium Dec 05 '21 at 22:46
@DebanjaB code not working See my code above which I have updated – anggun Dec 05 '21 at 23:00
@anggun Where are you stuck exactly? What error do you see? – undetected Selenium Dec 05 '21 at 23:03
element not found [link](https://ibb.co/VW4VNDf) – anggun Dec 05 '21 at 23:07

score 0 · Answer 2 · answered Dec 05 '21 at 17:27

0

First thing in selenium when you are writing selectors, always check their occurrence. If you want to click on particular element then selector should show 1 matching count. Now here you have use class value which looks like it have more than one matching node as well as you can use class value this way in selenium when there is more than one class(more words separated by space in class value).

So here I would recommend to use below xpath and before using it in your code, verify it if it is showing one matching node-

//button[text()='Upload Image']

answered Dec 05 '21 at 17:27

SelectorsHub - XPath Plugin

36
2

SelectorsHub - XPath Plugin not working – anggun Dec 06 '21 at 00:22
What error are you getting? Can you add 10sec wait before clicking on upload image button and see if it works. – SelectorsHub - XPath Plugin Dec 06 '21 at 03:45
no error but there is no click – anggun Dec 06 '21 at 04:13
How many match it is showing on that page for this xpath- //button[text()='Upload Image'] Please make sure it is finding 1 matching node. If possible, please your page link, I will help you with the solution. – SelectorsHub - XPath Plugin Dec 06 '21 at 18:07
Hello @ SelectorsHub - XPath Plugin After I tried on Selenium without Profile, Code successful, But, why if run on selenium chrome Profile, the code is not working , is there something wrong ? – anggun Dec 06 '21 at 23:21
If I use Chrome Default profile then the code doesn't work ,If I use Profile 2 Code works fine ,Where did it go wrong? – anggun Dec 07 '21 at 14:20

Click button in using VBA Chrome selenium

2 Answers2

Linked