Is there any way to get specific url after hitting a URL from VBA

svv 26 Reputation points

basically I need to call a URL(some auth based) from my VBA script. when i call it, it will open in browser with respective screen, after authenticating that page it will directing to other url in same page. i want to load that URL in my VBA code. Can you please help me. which library i need to use in VBA. i tried normal hitting with shell() Shell(chrome & " -url " & url) but by this there is no control on browser to VBA. also i tried selenium. i am unable to locate the URL. Dim driver As WebDriver

Set driver = New WebDriver
    driver.Start "chrome"
    driver.Get url
    driver.Wait 10000
    Url = driver.Url
    Application.Wait Now + TimeValue("00:00:20")

Please suggest required

0 comments No comments
{count} votes