How to find the button name and click it using VBA and Selenium?

Question

I'm trying to go to a LinkedIn website. I'm using Selenium and for some reason it does not recognize my saved user name and password so every time I open up a LinkedIn session, it is prompting me for those, but first since I already have an account, I have to click the Sign In 'button.' I'm pretty new to Selenium and not sure how to reference the web element.

This is a shortened version of the URL I get tripped up on: https://tinyurl.com/ygyw7eeo

This is a portion of what I think is the relevant HTML: Sign in

What I need is the VBA code to recognize that element and click "Sign Up" to take me to the next page where I input my email and password, then hit the Login button.

I've spent days on this and no idea so any help would be greatly appreciated. Thanks.

Private Sub Command175_Click()
Dim SeleniumEdgeDriver As New EdgeDriver
Dim strEdgeProfile As String
Dim SignInButton As Variant
'strEdgeProfile = "C:\Users\Jerry\AppData\Local\Microsoft\Edge\User Data\Personal"
strEdgeProfile = "C:\Users\Jerry\AppData\Local\Microsoft\Edge\User Data\Profile 1"
'.AddArgument ("profile-directory=foldername") 'foldername is the name of the folder with the profile you want to use
SeleniumEdgeDriver.SetProfile strEdgeProfile, True
SeleniumEdgeDriver.AddArgument ("--user-data-dir=C:\Users\[NAME]\AppData\Local\Microsoft\Edge\User Data\Default")
SeleniumEdgeDriver.AddArgument ("profile-directory=C:\Users\[NAME]\AppData\Local\Microsoft\Edge\User Data\Default")
SeleniumEdgeDriver.Get ("http://www.google.com")
SeleniumEdgeDriver.Get ("https://www.linkedin.com/feed/")
'Wait for the page to load code
While SeleniumEdgeDriver.ExecuteScript("return document.readyState") <> "complete"
 SeleniumEdgeDriver.Wait (5000)
Wend
'Click the Sign in button-All of the commented out things are what I've tried that didn't work!
'I tried to set my user profile where the login name and password were stored and that is not working
"I also tried to code to click the sign in button and that is not working becuase I'm not properly referecing the object
'SignInButton = SeleniumEdgeDriver.FindElementByName("auth_wall_desktop_profile-login-toggle")
'SignInButton.Click
'SeleniumEdgeDriver.FindElement(By.linktext("Sign in")).Click
'SeleniumEdgeDriver.FindElementByLinkText("Sign in").Click
'SeleniumEdgeDriver.FindElementByXPath("//button.form-toggle").Click
'SeleniumEdgeDriver.FindElementsByXPath("/html/body/main/div/div/form[2]/section/p/button").Click
'SignInButton = SeleniumEdgeDriver.FindElementsByXPath("/html/body/main/div/div/form[2]/section/p/button", 100, 100)
'SignInButton.Click
'SeleniumEdgeDriver.FindElementByClass("form-toggle", 2000).Click
'SeleniumEdgeDriver.FindElementById("auth_wall_desktop_profile-login-toggle", timeout:=0).Click ' no implicit waiting
'SeleniumEdgeDriver.FindElementByXPath("//a[@class='challenge-dialog']").Click
'SeleniumEdgeDriver.FindElementsByClass("p").Attribute("form-toggle").Click
'driver.FindElement (By.cssSelector("#shipping-method-buttons-container button"))
'SeleniumEdgeDriver.FindElementByCss("profile-card hidden").Click
'SeleniumEdgeDriver.FindElementByTag("Button", 2000, False).Click
'SeleniumEdgeDriver.FindElementByXPath("//div[@class ='data-tracking-control-name']/button/span/span[text()='Sign in']").Click
'SeleniumChromeDriver.Manage().DeleteAllCookies
SeleniumEdgeDriver.window.Maximize
SeleniumEdgeDriver.Wait 12000
SeleniumEdgeDriver.Quit
End Sub

• Lee Jensen: Welcome. Can you add your code to your question? It'll help the community figure out what's going on and give proper advice. Without a code sample, we're just guessing. Two, are you sure you want to use VBA? That's not a very common language to use for Selenium, so help might be hard to find.
• JerryW: Yes, unfortunately I have to be in VBA. My data is in Microsoft Access and VBA is the code of choice there. Usually I'm able to adapt from other languages as I can usually map the syntax. Thanks so much for your help.

Answer 1

for some reason it does not recognize my saved user name and password so every time I open up a LinkedIn session

By default, Selenium opens a "guest" window when running.

code to recognize that element and click "Sign Up"

You can use XPath //a[text()='Sign in'] to select the <a href="#">Sign in</a> link and then use XPath //button[text()='Sign in'] to select the <button>Sign in</button> button.

• user49364: thanks so much for your reply. Earlier today I was able to use this to get it to work, but will also tried your solution: SeleniumEdgeDriver.FindElementByLinkText("Sign in").Click()