Return current URL of Internet Explorer using VBA

[Oliver Dewar]

Hi Guys.

I have an excel app that navigates Internet Explorer to webpages via VBA.

I'd just like to know if there's a way to return the url of the current web page from Internet Explorer.

The reason for this is that I want to be able to check that I haven't been redirected to another domain. There are issues with using the status response for diagnosing redirections (if you don't know what they are then I won't bore you).

Thanks

 

[MacroWriter]

If you are using the internet explorer object say ie then use the below property.

currenturl = ie.LocationURL