Blog Azeroth

Hi All,

Firstly I want to say that I have been using a blogroll from Delmain. Now I love this blogroll. It looks great and is very functional. The only real problem I have is the time it can take to set it up (for noob coders like me) and the time it takes to add each new blog.

With that in mind I have created the following Spreadsheet.
Clicky

Basically there are 3 Tabs.
Custom Info is where you can personalise the global information.
Blog List is where you add your Blog Sites and Label them.
HTML Blogroll is the HTML Data you copy and paste into any HTML widget that supports Java.

I am really interested in feedback on this. Please also feel free to let me know if I missed you on the list.

I took a look at it, but didn't get a chance to test it out, very interesting use of Excel though. If I get a chance to try and implement on a test blog I will let you know.

Took a look at it - very well put together and very useful. Thanks!

Oh man, awesome. Definitely looks good. Thanks Razor.

Hey Raz.

I tried it yesterday and overall I have to tell it works great. I have a couple of questions about it. Like the order set up and how to add the link to the "Submit -Correct Your Blog" part.

How can you remove it if you don't want it?

I will try to talk to you in BA but if I don't see you soon, I'll just email you. Thank so much for the work you have done with it. It is a really great tool and makes such an awesome looking feature easy to work with!

Heya Bre!

You should just have to enter your email address in the field to get the submit link to work, its just an email link so will open the users email client.

To get rid of the email line.
First off, delete the email address on the "Custom Info" tab so the field is blank.
There is a hidden tab called "Web Data". Unhide this (rightclick on another tab and click unhide).
You will then need to Un-Protect the Sheet. This in version 2008, you click "Review" Tab then "Unprotect Sheet"
Cell B4, change from

to

Then change Cell G4 from

to


That should work.

On the "Web Data" page you can change the text "Submit-Correct your Blog" to anything you want.

The Order is covered by the Label and Title columns. It will go from top to bottum in that order. You can rename them all to suit.

Look forward to seeing what you come up with;)

Razor