I have an Edge browser open with one tab. I want to get the URL of the webpage into a variable in excel so I can create a hyperlink to it. I asked this question a couple years ago and received an answer that only works once. If I then navigate to a different webpage and run the macro, it pulls up the URL of the previous page, not the open one.