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:
If you paste the website directly into your web browser, you're automatically redirected to:
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?