Spy Journal 3.0 Filtering the web for you

And what a week is has been – with all sorts of amazing announcements, reversals and more on the Australian Domain Registration front with Bottle Domains and the auDA (Australia’s Domain Name Authority) slugging it out in the Supreme Court. This press release sum sit up well - auDA recklessness damages Australian domain industry

More Announcements:

Andy and Carrie Lee had their little baby. There was no sign of facial hair (fortunately!)

Service Pack 2 for the 2007 Microsoft Office System due to ship April 28th

Exchange 2010 Beta Released

Office 2010 announced – official press release - Next Wave of Microsoft Office Products Will Redefine How People Work

Updated Version of Outlook Connector 12.1 Available

And some other news:

Translate Your Outlook Emails into Other Languages

Word Team Blog blogger Joannie Stangeland started up a vodcast series called A Writer's Guide to Microsoft Office.

Tonight the site WMpoweruser leaked the image of the Zune HD – and world is awash with rumours surrounding its specs and capabilities – looks like a device that is way in front of any Apple iPod products with rumours of HDMI, HD display, touch screen, HD Radio and WiFi.

Robin Good has a fantastic guide on How To Blog Anonymously And Maintain Control Of Your Personal Privacy. He lists techniques, tools and other strategies.

He also has written this one How To Embed And Display RSS Feeds On Any Web Page: Best RSS-To-HTML Publishing Tools – linking to lots of great tools.

Today’s list of cool tools and weird things is brought to you by – well actually just me. But Kitty can hold her iPhone next to her Dell Laptop showing that she loves both PC and Apple. and yes pink is her favourite colour!

Lets start off with some Microsoft Technologies

Amit has written a good how to article explaining How to Insert Images in a Word Document without Embedding

john has written about his ongoing OneNote testing as part of the OneNote development team in at Microsoft. Interesting stuff. We love OneNote here – its our primary team communication tool (after Outlook) and we use Livemesh to synchronise our shared notebooks with our team spread around the world.

www.ferrari.com is written using Sharepoint Designer (now being offered for free) and is published with a Sharepoint Backend. Awesome! I like the 612 Scaglietti best.

Philip writes Exchange Integrated Outlook – Recovering Deleted Items. A good detailed how to.

Weird and wonderful

Cake Wrecks has some photos of awesome cake decorating – Stargate style!

Ok so that title was a little contrived – and only because my wife bought the classic Jules Verne book yesterday along with Mark Twain’s Tom Sawyer, Louisa Alcott’s Little Woman and Jack London’s Call of the Wild.

This article has a bunch of cool Microsoft Excel related content from all around the world.

10 worst Microsoft Excel practices. Michiel has created this list, but I certainly wouldn’t rank them the same way.

My Top three would be:

• Linked spreadsheet files (workbooks)
• Merged Cells
• Combining reports and data tables on the same worksheet – Michiel’s number 9. The other two don’t even make his list.

Allen Wyatt has a great article providing some VBA code to detect errors in conditional formatting formulas. This is a very practical solution to a very real problem.

Doug Klippert has posted some code from Peter Beach an Excel MVP that will create a list in Excel of all the folders on a drive and their sizes.

Andrew Engwirda has added some cool chart tools to his free Excel Tools. (News flash – he might come back to work for me! – Stay tuned)

Dick’s Daily Dose of Excel has two interesting posts (well lots actually but two I picked out) – the first written is on displaying image galleries in the ribbon written by Ron de Bruin, and the second titled Elle’s birthday.

Joseph has a very good explanation written for the new Excel 2007 tables of how not to break your summing formulas. The same concepts apply in Excel 2003 for the auto sum function using the Sigma button the toolbar.

Oh and that’s a photo of Kitty pretending to be interested in spreadsheeting techniques. Kitty is a business analyst working for Jethro.

I have learnt the hard way over many years ways of speeding up VBA code. Mostly these lessons have come from necessity – the old “go and have a cup of coffee while it runs” comment doesn’t always endear your code to the customer. We have in the past written thousands of lines of code that sometimes takes minutes or even 10s of minutes to run.

Some of the quicker ways to speed things up are in turning off things in excel like calculation, screen updating and the like. Others involve using arrays in code to handle slabs of data and manipulate them in code before returning the results back to the spreadsheet. Others are little things like not selecting ranges etc before using them.

Chad Rothschiller has written a great article on Excel VBA Performance Coding Best Practices going through all these items and explaining how to optimise your code for efficiency. These are beginning tasks. There are certainly lot more complex ways to deal with some of these things but for anybody who started writing VBA by using the record macro function, as I did way back in the early 90’s these tips certainly allow you to speed up some of the very inefficient code that that method creates.

I have highlighted some of them here and added some additional notes.