Spy Journal 3.0 Filtering the web for you

SEO or Search Engine Optimisation is paying off for me.

I have an unfortunate name. Tim Miller is a pretty common name. So when you do a Google search for me you cant find this Tim Miller, instead you find a whole bunch of other people. This is part of the reason I have promoted my blog as SpyJournal. Its a unique name and its the name I use for most of my social websites and so on. Our business names also of Jethro Management and Jethro Consultants are pretty unique.

  So when I do a Google search for SpyJournal, every single entry on the first page is me. Jethro Management is the same, and Jethro Consultants has the second last one only as not me. 9 out of 10 or 10 out of 10 results is pretty good. I think I have a pretty good chance of getting found with my company name. By the way I would be interested if readers in other countries could try the same thing and let me know in the comments what you find. Feel free to use other search engines, though Google is of course the main one. I cant remember the time I needed  to try a different one!

The next step for me is to keep working on my keywords, specifically Drupal and Excel and Excel VBA.

I have received numerous jobs recently through from people who found us with Google searches here in Australia. More in the last 6 months than in the rest of our business history so far.

I have been requested numerous times recently by readers in comments and emails to write some how to articles for VBA. It is my intention to start to do this.

My basic plan will be to take situations where new VBA users record some code with the VBA recorder, and then want to try and make it more robust.

An article by Nick Hodge (the Excel Nick Hodge) on Dicks Daily Dose of Excel website illustrates my point.

I probably will not write articles as long or as in depth as he has done. Instead I will focus on small parts of this code such as range selection, switching workbooks, defining variables and constants and using them etc. Specifically each article I write will have real practical application. E.g how to copy data from one file to another, how to save a spreadsheet as values for emailing etc.

In the meantime enjoy Nicks article on his coding technique particularly the latter stages where he talks about the progression in code development in VBA.

I have something like 20 or more websites open in browser that I want to be able to review or recommend. I haven’t got time so I will link them here, tag on delicious and clip into socialmedian as appropriate.

Here goes.

Microsoft

• Windows Live One Care for Server. Free trial. Works on Server 2008 Standard 64 bit, SBS 2008 Standard and Premium.
• File Dialogs – adding My Places in the File Open and File Save As dialog boxes. Quickly find frequently used locations on your PC or network.
• Adding signatures to email in Windows Live Hotmail
• Plugins – Flickr for Live Writer, Flickr for Outlook, Flickr for Word. Zemanta for Windows Live Writer. Hat tip to Sarah Perez from Channel 10 for this. (see our Geek Girl profile on Sarah)
• Another from Sarah is the Circle Dock Application launcher. Go straight to Circle Dock.
• How to share large files without attaching them to email
• Bulk convert old documents to new Office 2007 format from Digital Inspiration. I will be trialing this with a set of copied documents to test the results.

online at the shops with unsecure wireless network