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…
Tag: Excel
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…
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…
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…
Excel VLookup Function
A wonderfully powerful and easy to use way of comparing data across Excel worksheets is the VLookup function. I’ve been helping a lot of people with this function lately, so I thought…
Crystal Xcelsius – Excel is Busy
Crystal Xcelsius – Excel is busy… If you’re a user of Business Objects Crystal Xcelsius and you’ve seen this message, you know my pain. “Excel Is Busy Please Close Excel” So I…
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…