Opening website, getting data, closing website

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?

*bump*

I managed to find the ShellExecute function in the library, and have used that to open up a browser window. How, then, am I able to take the expanded URL back from the window to use it in other parts of my spreadsheet? (Text management stuff, and the like).

A solution to this would also solve my problem. Returning a extended url into the cell which I can then manipulate further.