I have a spreadsheet with a single column -- each cell within this column is the basic URL for a website. I'd like to write a macro that opens up each website in turn, and converts the basic URL to its corresponding extended URL.

Example: the first value in the column might be:

http://www.company.com/ABCDE

If you paste the website directly into your web browser, you're automatically redirected to:

http://www.company.com/Example-Long-URL.html

I'd like to write a macro that takes the first URL, goes to the website, and comes back with the second URL, which can then be pasted back into the worksheet, on a row-by-row basis.

Can such a beast be done?