Amazon Ad Link Generator add-in for Excel
February 26, 2009 • JP • 1 Comment • Rate This Article
• Links to this article
I've recently completed another add-in for Excel. This one generates affiliate links for Amazon.com products, for webmasters and bloggers who use Amazon Associates to generate income from their websites.
Creating Amazon links by hand is hard work, and after months of doing it this way, I thought there must be a better way. This add-in lets you choose from a variety of options, including nofollowing links, having links open in a new window, and picking the size of the image.
The interface is straightforward, but you will need some knowledge of HTML to understand what some of the terms mean. Here's a screenshot:
Special thanks to Dick Kusleika from Daily Dose of Excel for testing it out and suggesting improvements.
Code Locked Versions:
Amazon Ad Link Generator Add-In – Excel 2000-2003 version
Amazon Ad Link Generator Add-In – Excel 2007 version
Code UN-Locked Versions:
Amazon Ad Link Generator Add-In – Excel 2000-2003 version
Amazon Ad Link Generator Add-In – Excel 2007 version
To install the add-in, open the zip archive and save the .xla or .xlam file to the folder of your choice. Start Excel and go to Tools » Add-Ins and click Browse. Find the file you saved. Make sure the checkbox next to the add-in name is checked, and click "OK". You must have an Amazon Associates ID in order to use the add-in; if you don't have one, visit their site (link is at the top of this post) and create one first.
Once installed, there will be a new item on your Data Menu: Amazon Ad Link Generator. Select it to open the form and begin link building. At minimum you will need to enter title, ISBN and your affiliate ID before you can generate the HTML code. Here's a sample of the completed form.
The zip file also includes a readme.doc for further assistance.
So far I'm up to seven Excel add-ins, is that a record? 
I'm also producing a Java version of the add-in, for those of you inclined to use the code outside of Excel. It will be a Java class with a GUI interface, just like the add-in. It will produce the code in a textbox and will not use Excel at all. Most of it has been written already, but further testing is needed.
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Bounced email list maker
Next Post: Future plans
Thanks for this!