Tag: VBA

  • 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 […]

  • 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 […]