Tag: Excel
-
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 […]
-
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 I’d get a quick tutorial out there. Let’s start with the syntax of the VLookup function: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Here’s an example […]
-
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 make sure Excel is closed. I even check the task manager to see if there are any hidden processes running. Good. Excel is […]
-
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 […]