Make Imported Links Live in Excel

This Microsoft Excel macro was developed to make our work easier, and will automatically make up to 10,000 rows of links “live” in a spreadsheet, the way you intended to use it.

Isn’t it a shame that MS Excel is just “too stupid” to do this automatically? The sample spreadsheet with the embedded macro is provided here free for you to download, and here are the directions…

Update 2011 – Macro no longer needed!
Watch this 3 minute video to see the new Add-in for Excel in action…

1. Download the spreadsheet, and note the “security” warning that will appear (in Excel 2007) above column A, which simply tells you that there’s a macro in need of enabling.

2. Hit “Options” to enable the macro by choosing “Enable This Content” and checking the radio button that says “Enable macros in this document”.

3. Import or paste your links into an empty version of the spreadsheet. Currently, in the file you download, column A is labeled for URL’s, but thats not a requirement, so feel free to change it.

4. Then all you have to do is click on the top link in the column that you wish to “activate”, and press the button to make all of your links instantly live.

5. Feel free to leave comments about this tool here and/or Stumble, Digg, etc. below.