Tag: Macro

  • SEOmoz Mozscape Add-In For Excel

    With the updates just added to the Mozscape API (previously Linkscape), I decided to update the Excel Macro and turn it into a full-fledged Excel Add-In. Features: Select any number of cells containing URL’s. Right-click and select “Run Mozscape on Selection” Enter your Access ID and Secret Key (aka Private Key) from the api page. […]

  • Update: Version 2.0 of the Excel Interface to the seoMoz API

    I’m very happy to announce an updated version of our Excel Interface to the seoMoz LinkScape / Mozscape API. Your suggestions have been heeded and the new version is a great improvement over the first. What’s new? Run On-Demand: No more auto-updating. Now, just press Alt+F8 to run when YOU want. Rate Limiter: Helps to […]

  • Using the SEOmoz Free API with Excel

    At one time or another, we’ve all come across a “juicy” list of directories, blogs, or other websites that we might be able to use for some link building. I recently came across such a list and was quickly annoyed at how low the quality of some of the sites was. I wanted a quick […]

  • Excel Macro to Generate SQL Insert

    I am in the process of creating a database of County information, and I needed to insert several thousand records. I was able to get the data into Excel, but now I needed to write an SQL Insert statement to get the records into my database. SQL wizards, I’m sure you know a more efficient […]

  • Outlook Attachment Reminder Macro

    How many times have you written an email about “the attached file” only to forget to attach the file before hitting send? If you follow the instructions in this post, that’ll never happen again! We’re going to add a VBA macro to Microsoft Outlook that searches your email for the text “attach” when you click […]

  • Excel Macro Spreadsheet to HTML

    So I have a customer that needed a registration page for their E-University. This consisted of about 500 courses in various categories. I got the ~great idea to implement an AJAX Accordion to contain the categories. Within each accordion pane, I needed separate tables to house the various sub-categories. So how do I get a […]