However, stage 5 of the Trust House Cycle Classic was scheduled for January 31st 2010 around the streets of Wellington and it went ahead as planned. The original schedule was to be a 60 minute race around a closed criterium circuit + a 3 lap dash after the completion of 60 minutes racing to sort the racers from the coat-tailers.

I decided a few weeks ago to put together my gear and head out to take some shots of the race. I took a few and have put a select few on flickr in an album simply called Trust House Cycle Classic, Stage 5. The gallery below contains the same shots as the flickr set but I’m putting them up here anyway – hope you enjoy them.

Related posts:

1. Monkey Kick Off … victory at last! Yes! I finally beat Annie at Monkey Kick Off –...
2. Playing with HDR Photography It’s been a while since I put anything on this...

Related posts brought to you by Yet Another Related Posts Plugin.

Please feel free to contact me through my contact page if you need clarification on or want to discuss any of the information in this post.

I apologise in advance for the length of this post … I tend to go into a lot of detail when writing posts like this. I hope it all helps someone though.

To begin with, you’ll need a few things before you even get started. Here’s a brief, but not exhaustive, list of things you’ll need.

1. A domain name. The domain registrar you choose is up to you – it would be irresponsible of me to say that any particular registrar is better than any other.
2. A web hosting account. I use ICDSoft – this is one situation where I’m happy to say they’re better than any other Linux host I’ve ever used.
3. A copy of the latest version of Wordpress. As of today, January 16th 2010, this is version 2.9.1 and can be downloaded from http://wordpress.org/.
4. A theme. Wordpress has possibly the best theme support around so this is quite important. Personally I use theme from Elegant Themes. Pick one, download/purchase it and have the files ready for later steps.
5. FTP credentials. You’ll need to know the DNS address or IP address of the FTP site that supports the final, published URL, as well as the username and password to login there. I use the free FTP client, FileZilla – it’s free and works on OS X (Mac), Linux and Windows.
6. MySQL credentials. You’ll need to know the connection address or IP address of the MySQL server that will support your Wordpress installation, as well as the username and password used to connect.
7. An empty database ready for your Wordpress installation. You don’t need to put anything in it – the Wordpress installation scripts will do that for you.

Once you’ve got these things sorted you can start on the actual installation & configuration. Here goes.

1. Follow ‘The Famous 5-Minute Installation’ written by the Wordpress guys. There’s no point reproducing or rewriting this here – these instructions are as good as they come. This will get Wordpress running. During this step I highly recommend editing wp-config.php and changing the $table_prefix to something other than wp_ – if you don’t the security scan plugin coming up will say you should’ve changed it … by then it’s too late without causing yourself some pain.
2. Make sure your Wordpress site works – all you should see at this point is the default ‘Hello World’ post and a single comment on that post.
3. Delete the single existing comment and the ‘Hello World’ post – you don’t need them.
4. Under Settings > Users setup a user account for yourself. Note that this username, depending on your theme choice, will be the author of any posts you write while logged in (assuming you don’t force the author name to be something else). For this reason you should decide now if you want it to be capitalised or not (mine is as my username is my name).
5. Optional but recommended: If you know how to, use phpMyAdmin to change the login name for the default Wordpress ‘admin’ account. This is a recommended action for increased security only. The table you’re looking for in your database is the $table_prefix setting mentioned above plus _users. E.g. if your $table_prefix is the default ‘wp_’ the table would be called ‘wp_users’.
6. Extract the theme you downloaded earlier and upload it to /wp-content/themes/. Alternatively you can use the ‘Add New Themes’ link in the Wordpress Dashboard but I’ve had issues once or twice with this. For that reason I always install themes via FTP.
7. If your theme requires additional plugins upload them to /wp-content/plugins/. The Elegant Themes themes, in most cases, requires accompanying plugins. Make sure you upload and enable them before you enable the theme.
8. If you haven’t already you can enable your selected theme now.

The list below is a list of the plugins I currently use on Digital Formula and that I think most blogs should have. It doesn’t contain plugins that I use specifically for this blog. Your list may be different – that part is up to you. Note that I’m not linking to any plugins as plugin authors sometimes change the location of their plugins. To find them you only need to use the ‘Add New’ link under ‘Plugins’ in the Wordpress dashboard.

1. Akismet. This plugin comes with Wordpress and is basically the world-standard for Wordpress comment spam protection. For it to work properly you’ll need to register a user account on Wordpress.com and get an API key – choose the ‘Just a username, please.’ radio button near the bottom of the sign-up form otherwise you’ll be creating an entire blog, too. Once you’ve registered you can go to http://dashboard.wordpress.com/wp-admin/profile.php to get your API key – it’s near the top of the profile screen.
2. Fast and Secure Contact Form by Mike Challis. This is a very nice plugin for easily creating a ‘Contact Me’ form.
3. FeedBurner. This ties into the RSS feed links for your blog and allows you to manage all your feeds from one place as well as see how many subcribers you’ve got.
4. Google Analyticator. Who doesn’t want to know how many visitors they get? Go to http://analytics.google.com, follow the easy-to-use sign-up instructions and note down the UA code. Install the Google Analyticator plugin and, in the settings page, paste the UA code you noted down a few minutes ago. Simple.
5. Google XML Sitemaps. Again, pretty much the standard for making sure search engines can crawl your site effectively.
6. Platinum SEO Pack. Maximises SEO (Search Engine Optimisation, sorry for my non-US spelling) and makes sure your site is as “find-able” as possible.
7. SI CAPTCHA Anti-Spam. Another excellent plugin by Mike Challis. This one adds CAPTCHA functionality, by default, to your comment forms to try and minimise web bots sending you comment spam.
8. Wordpress Database Backup. Excellent backup plugin by Austin Matzko that allows you to carry out scheduled database backups and save them to your server or have them emailed to an email address of your choice.
9. WP Security Scan. This one’s for scanning your Wordpress installation to make sure it conforms to recommended security settings. If you didn’t change the $table_prefix in wp-config.php and rename the default ‘admin’ account as recommended earlier in this article, the WP Security Scan plugin will let you know in no uncertain terms that you SHOULD HAVE. It will also say that you should have an .htaccess in /wp-admin – go ahead and make one then upload it. There may also be some recommendations about setting file permissions on the various directories within your Wordpress installation – I always change these but that sort of change is up to you.
10. Yet Another Related Posts Plugin (YARPP). Does what it says – displays related posts when you view any post on the site.

1. Add to Any. This small plugin allows you to add links to popular bookmarking/social networking sites. Simple in its simplicity it’s a great way of helping your readers link back to your site (and therefore help your page rank in Google if YOU link to them).
2. Breadcrumb NavXT. Gives the option of adding breadcrumb links to the any point in your pages/posts. Personally I’m a big fan of breadcrumbs as they give readers the option of back-tracking back through the path they came in on, depending on your configuration of course.
3. Lightbox 2. Used properly this widely-known and popular technique can give your image links some power. Instead of linking to a relatively boring image they can be made to popup in a much cooler way – you’ve seen this before but maybe not known it’s called Lightbox.
4. WP-CodeBox. This plugin is aimed exclusively at people with code on their sites. Code snippets can be displayed with syntax-colouring/highlighting to make code reading much more effective.
5. WP-PageNavi. As the plugin’s own description says, “Adds a more advanced paging navigation to your WordPress blog.”

Some of the steps below are recommended, some are completely optional but still things I do on each Wordpress site I create. I’ll leave it up to you as to whether or not you do them on your own site. They can, amongst other things, inform social networking sites when you add content and therefore drive more traffic to your site. All these options are under the ‘Settings’ section on the left of the Wordpress dashboard.

1. General > Tagline. The appearance and location of this is theme-dependent but will inform readers, at a glance, what your site is about.
2. General > Timezone. For obvious reasons you should set to the appropriate time zone for your site.
3. Writing > Remote Publishing. If you want to use a desktop client to publish your articles (e.g. Microsoft Live Writer) you’ll need to enable these options.
4. Writing > Update Services. My list of update services can be downloaded from the Digital Formula Downloads page.
5. Reading > Front page displays. Change this to be a static page if you don’t want your site’s entry page to be a list of your latest articles. If you’re using a theme from Elegant Themes some of the will override this setting – please take this into account before asking “Hey, why won’t my static page show up?”
6. Discussion > Other comment settings > Enable threaded (nested) comments ‘X’ levels deep. This is disabled by default – I always set it to 5. Discussions look better that way.
7. Discussion > Before a comment appears > An administrator must always approve the comment. If you install the ‘SI CAPTCHA Anti-Spam’ plugin mentioned above it’s pretty safe to disable this. Only web bots (and people) clever enough to figure out the CAPTCHA images can submit comments anyway.
8. Permalinks > Common Settings. I always the custom structure ‘/%category%/%postname%/’. It looks far better than the default and is also SEO-friendly.
9. Miscellaneous > Uploading Files. Worth mentioning but I always leave these at the default settings. If you want to organise your uploads a different way you can change the settings here.

I hope this article helps someone. These settings, plugins and recommendations have helped my blog’s traffic, according to Google Analytics, from increasing by 15-20% each week to over 60% each week. They work for me and, provided you add decent content to your blog, they’ll work for you, too.

Related posts:

1. Pay it forward … For a few years now I’ve been dabbling in a...
2. Erin King Photographer You may have noticed that over the past week or...
3. What tools, software & applications do I use? This post is intended as a couple of things. Firstly,...

Related posts brought to you by Yet Another Related Posts Plugin.

I’ve actually had a couple of people ask me what tools I use for various tasks so I’m going to compile a list of the various applications I use ‘every day’. That’s in quotes as obviously I don’t use all of these tools EVERY day but I consider them part of the list of tools I couldn’t do without. I don’t use anything particularly special but I’ll make this list for those that’ve asked anyway. Secondly, I keep meaning to make a list of tools I use for my own reference so it’ll double as that, too.

I’m not going to go into a whole load of detail about what the benefits of each one are – I’ll let you work that out for yourself if you want to try them (feel free to contact me if you want to discuss any of these though). I will include a couple of things which aren’t strictly applications too, e.g. hosting services. So, here we go – these details are correct as at January 16th, 2010.

Operating system :: OS X 10.6.2 (Snow Leopard) on 27″ iMac. I made the switch from Windows a month or 2 ago and am wishing I’d done it years ago.
Office Suite :: Microsoft Office 2008 for Mac … unfortunately I have to say that compared to the Window version this really is quite crap.
Email client :: Thunderbird 3
App dev environment :: Xcode 3.2.1 when writing for OS X, Visual Studio Express (C#) when writing for Windows (Parallels Desktop)
Web dev environment :: Aptana Studio 1.5 w/ Aptana PHP Plugin – unfortunately 2.0 is still a bit too buggy for me.
MySQL administrator :: Navicat Lite
Text editor :: TextEdit, built into OS X
FTP client :: FileZilla 3.1.1
Primary browser :: Firefox 3.5
Twitter client :: Tweetie
Password storage :: KeePassX – *highly* recommended on both OS X and Windows (the Windows version is called KeePass).
iPod manager :: iTunes – on OS X it’s actually really good and 100x more stable than the rather pitiful attempt iTunes for Windows is …
CD/DVD burner :: None, built into OS X
Photo processing :: Adobe Photoshop Lightroom 2.6 – I used to use Capture One 4.8 from Phase One but it started to fall WAY behind Lightroom in terms of post-processing options … a real shame.
Fitness management :: Polar ProTrainer 5 inside Parallels Desktop
Instant messaging :: Windows Live Messenger
Movie player :: VLC (everyone should use this although it struggles with the TSCC codec unfortunately)
Audio player :: iTunes
Archiving utility :: Built into OS X

One thing you might notice is they’re pretty much all free tools with the exception of Lightroom and Polar Pro Trainer 5, all of which I own licenses for (no they’re not pirated!).

Website host :: ICDSoft – these guys are AMAZING. I wouldn’t use anyone else for Unix hosting.
Email service :: Gmail
Blogging engine :: Wordpress 2.9.1
Online photo sharing :: Flickr (I own a ‘Pro’ account)
RSS feed management :: FeedBurner
Website statistics :: Google Analytics
Search engine :: Altavista … haha yeah right.
Bookmarks :: Delicious – I stopped using browser-based bookmarks many years ago.

That’s about it really. As I said earlier I’m happy to discuss any of these if you like – just post a comment or use the Contact Me link at the top of the page.

Thanks!

Related posts:

1. What tools, software & applications do I use? This post is intended as a couple of things. Firstly,...
2. PowerShell – Optimised Applications I’m pretty keen on finding ways to keep my system...
3. 27″ of shiny glass fruit? Well, I’ve finally done it. I’ve switched from Windows to...

Related posts brought to you by Yet Another Related Posts Plugin.

Anyway, I used to learn from a bunch of talented dudes over http://www.3dcaffeine.com, a site that unfortunately no longer exists (internal problems? I don’t know.) One of the members there was a Romanian guy by the name of Flavius, a very talented 3D designer with a pretty scary level of skill for someone his age, around 20 as I write this I think … no he’s not a Romanian scammer!

He’s in the unfortunate position where web hosting and all the bits that go with it are pretty hard to come by so I decided to do as the title of this post says – pay it forward. To do this I offered to pay for web hosting and domain registration for a website to be created, a site where Flavius could showcase his work, demonstrate his skills and get the word out there so that people know there are talented designers everywhere.

The site’s now live and, while it’s yet to have much content (it’s been live around an hour now but will undergoing plenty of changes over the next little while), is coming along nicely with a decent gallery to get started, backed up by a beautiful Wordpress theme by Nick Roach over at Elegant Themes. Go there if you want themes – it’s the site I choose to use for all my Wordpress themes.

Flavius’ new site can be found at http://flaviuscristea.com and will have more content added as time goes on. Please feel free to let me know if you find any problems there as I’ll be doing the back-end maintenance of the site even though Flavius will be maintaining the actual content.

Cool.

Related posts:

1. Wordpress ‘How To’ Guide So, as I usually ask near the start of my...
2. Erin King Photographer You may have noticed that over the past week or...

Related posts brought to you by Yet Another Related Posts Plugin.

Firstly, I’ll just say that this page isn’t going to be about how to use jQuery, AJAX or anything like that; there are many thousands of pages on the web already that do a far better job of that than I could. As a starting point I’d highly recommend the jQuery documentation – it’s pretty good.

Here’s my jQuery function that gets triggered when the submit is clicked.

   <script type="text/javascript">
      // jQuery script
      $(function() {
         $('#return_message').hide();
         $("#save_button").click(function() {
            var style = $("#style").val();
            var dataString = 'action=set_style&style=' + style;
            $.ajax({
               type: "POST",
               url: "include/ajax.php",
               data: dataString,
               success: function(response) {
                  if(response.indexOf("error") > 0)
                  {
                     $('#options_form_div').html("<div id='message'><span class='return_message_bad'>Oops, something broke while saving the configuration!&nbsp;&nbsp;Please <a href='__admin.php'>refresh this page</a> and try again shortly.</span></div>").hide().fadeIn(1500, function(){
                        $('#message');
                     })
                  }
                  else
                  {
                     $('#options_form_div').html("<div id='message'><span class='return_message_ok'>Great, everything worked and your new configuration has been saved successfully!<br />Please note that if you changed the style the new style will be visible the next time this page is loaded (or you can click <a href='__admin.php'>here</a>).</span></div>").hide().fadeIn(1500, function(){
                        $('#message');
                     })
                  }
               }
            });
            return false;
         });
      });
   </script>

And here is the part of ajax.php that matters:

$result = $database->DoQuery($query, $database->connection);
if (!$result)
{
   $return['error'] = true;
   $return['msg'] = 'Error updating style.';
}
echo json_encode($return);

The success(response) part of the jQuery script above is the key part – without it you’ll never know if your PHP file (ajax.php in this case) returns an error. If ajax.php exists and you don’t have the response set as a parameter, the jQuery function will be successful even if the PHP file throws an error.

I’m sure there are other, more elegant ways to do this, perhaps in the jQuery documentation. This way works for me though.

Related posts:

1. MS Access and C# – Syntax error in INSERT INTO statement Recently I was working on a small application that required...
2. C# – Generate Random String While writing a web app recently that needed to get...
3. VB.NET – Validate AD user Yesterday I posted an article about how to list all...

Related posts brought to you by Yet Another Related Posts Plugin.

I took a few shots to ‘document’ the photoshoot for Erin – here are a couple of the ones I took of Judy, the bride-to-be.

Erin’s professional website can be found at http://www.erinking.co.nz – I’d highly recommend heading over there and having a look, especially if you or someone you know is looking to commission a very experienced and professional photographer.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Both iMac machines at my place are used with Adobe Lightroom for photographic processing. Today I needed to transfer some photos from one machine to the other but Lightroom wouldn’t transfer the develop settings, only the files themselves. Here’s how to transfer the develop settings too.

By default Adobe Lightroom is configured to only store photo development information in the Lightroom catalog. This is fine if you only ever plan to develop photos using Lightroom using a single computer. However, if you want to transfer photos to another computer *and* keep the develop settings you’ve applied, the file will be transferred without the develop information. There are a couple of ways of getting around – here are the main ones.

• Transfer the original file to the other computer with a sidecar XMP file (XMP stands for eXtensible Media Platform). The XMP file is a companion file that can go with the original RAW file to retain develop changes.
• Use the increasingly popular DNG file format (DNG stands for Digital NeGative) and ensure the develop info has been saved into the XMP space within that file.

The XMP sidecar method is simple. If you use Adobe Camera Raw (ACR) to modify your original RAW files (e.g. CR2 for Canon, NEF for Nikon) just make sure the XMP file with the same name as the original image is transferred with the original image. ACR will recognise this file and load it accordingly. The XMP file be automatically created as soon as you make a modification to the original image.

The second method is what I choose to use as it combines the original image and the XMP data into a single file.

If you want to use DNG files within Lightroom, something I think is good practice, you need to do a couple of things. Please note that I’m using Lightroom for Mac on OS X Snow Leopard – the dialog boxes will look slightly different if you’re using Windows.

• When you import your images into Lightroom import them as DNG files immediately, as shown in the screenshot below. To bring up the import files dialog click the File menu and select the option that suits you, e.g. ‘Import Photos from Disk…’)

• Convert your existing images to DNG after they’re in your Lightroom catalog. This can be a time consuming process, depending on the speed of your computer and/or the number of images already in your catalog. To do this select the images you want to convert and click the Library menu then the option labelled ‘Convert Photos to DNG’ (or ‘Convert Photo to DNG’ if you have only 1 selected). The import window looks like the image below (these are the settings I use – be aware of the option that says to delete originals after successful conversion).

Ok so that’s your catalog nicely full of DNG files. Where to next?

The next step is to ensure that the DNG files also contain the XMP develop data – this is NOT the default setting in Lightroom 2. To do this select the Lightroom menu on OS X and select Catalog Settings or press Option+Command+, (on Windows select Edit then select Catalog Settings or press Ctrl+Alt+,). The following dialog will appear (select the Metadata section if it’s not already selected).

As you can see the box labelled ‘Automatically write changes into XMP’ isn’t checked – this is the Lightroom default setting. This means that any changes you make to the DNG file will be saved into the Lightroom catalog *only*; the italic text directly below option confirms this for you. To change Lightroom so that it saves develop information into the XMP space within the DNG file, enable this option and close the catalog settings window (on Windows change the setting and click OK). From now on the DNG files you use will contain the original image and any develop changes you make.

Good question! The answer is no, they won’t contain the develop info yet – luckily the solution is easy. If you want to make it so that your existing images contain the XMP develop data (assuming they’re DNG) firstly make sure you’re in the Lightroom Library module (the first link in the 5 links near the top-right of the Lightroom main window). Then you simply need to select the images you want to modify, click the Metadata menu and choose ‘Save Metadata to Files’ (or ‘Save Metadata to File’ if you’ve only got 1 file selected). On OS X you can also press Command-S or Ctrl-S if you’re using Windows. This will write the changes you’ve made, if any, to the XMP space within the DNG file.

From now on the DNG files are fully portable! You can take them in their current form – the DNG files – and copy them to a new PC or send to someone else without fear that your develop changes won’t go with them.

My disclaimer for this post is that you should be doing regular backups of your important data. If you’re already doing regular backups you have nothing to worry about; in the unlikely event that something does go wrong, you can restore your files from backup (if you’re not backing up your data PLEASE start doing it now, for your own sake). The above steps are non-destructive and safe for your images – I use this option and have never had a single problem with any of my images.

Related posts:

1. PHP script to show files in directory with a bit of style – v0.4 I’m undecided on how to go about posting updates that...
2. PHP script to show files in directory with a bit of style – v0.3 This is a re-write of a post I made I...
3. Microsoft Excel – Delete matching rows As part of my new role at Fujitsu here in...

Related posts brought to you by Yet Another Related Posts Plugin.

For a long time I’ve been doing a lot of work with Wordpress, PHP and generally non-Microsoft things while at home which means that being tied to the Microsoft platform isn’t something that worries me anymore. Initially it’s a pretty steep learning curve as I’ve been using Windows for so long that I’m pretty quick with the keyboard shortcuts and rarely, if ever, use a mouse in Windows (yes there are exceptions, obviously). That learning curve becomes pretty flat very quickly though. For example Ctrl-C and Ctrl-V, 2 of the most commonly used shortcuts in Windows, are now Command-C and Command-V. The mini wireless keyboard that comes with the new iMacs has no arrow keys or number pad but that’s cool because I’ve had an Apple keyboard for a while now and that has all the keys that are missing from the new one. Although the new Apple Magic Mouse seems like a weird idea at first, it’s actually surprisingly usable (although the gestures suck if they’re in any direction other than vertical … and your mouse isn’t glued to the desk). I use a wireless Microsoft Explorer mouse anyway which is 100% compatible with OS X.

I’ve been supporting Windows and related bits for a VERY long time now and making the switch wasn’t something I could have realistically done before. Those Windows-specific days are in the past though and I’m REALLY enjoying the slick feel of OS X and apps that, while they work on Windows, were originally designed for Mac anyway. Especially iTunes, which is a complete pig on Windows … it runs lightning-fast on OS X. With 3 iPods, iTunes is pretty much a necessity, especially with the iPod Touch being unsupported by many other iPod management packages out there (if any).

Literally *all* the apps I use on Windows for the work I’m doing now are available for OS X. Some of them include:

- iTunes (iPod management as mentioned above)
- FileZilla (FTP client – the new tabbed version ROCKS)
- Aptana Studio (PHP development, although I’ve gone back to using version 1.5 – see this post)
- Mozilla Firefox (web browser)
- Mozilla Thunderbird (email client – v3 RC1 seems really good so far)
- Microsoft Office including MSN

The only application I can’t use natively with OS X and that I am praying will be supported one day is Polar Pro Trainer 5, the software that comes with my Polar RS800CX heart rate monitor (I do a lot of cycling). Parallels’ Coherence mode solves this one too though. Sweet!

I was a big fan of Windows Media Center while using Windows 7 but OS X Snow Leopard’s Front Row kicks ass!

Toni … if you’re reading this, yes I miss Google Chrome but it’s coming soon for OS X.

To be fair, Windows 7, as I mentioned above, is seriously awesome and it’s still my OS of choice at work, even in a strictly-controlled corporate environment.

So that’s that really. Personal preference plays a big part here and I’m not saying OS X Snow Leopard is better than Windows 7 … that’s been covered by people better qualified to comment than me.

P.S. No I don’t have a black high-neck sweater … yet.

Related posts:

1. What tools, software & applications do I use? v2.0 This post is intended as a couple of things. Firstly,...
2. What tools, software & applications do I use? This post is intended as a couple of things. Firstly,...

Related posts brought to you by Yet Another Related Posts Plugin.

Microsoft Excel is ok at importing data from CSV files but can’t handle these files too well as there’s no uniform pattern that it seems to be able to match (it matches to the human eye but I guess not to Excel’s internal algorithms or something).

Anyway, to import these files into Excel I needed to do 2 things which seem pretty simple but that you really don’t want to do when the files are as big as these ones – 40MB+ of text. Yuck. Please note that the first step below works in both Excel for Windows and Excel for Mac but the second part, because it contains VBA script does not work in Excel for Mac (VBA isn’t supported in Excel 2008 for Mac). See the criticism section of this Wikipedia page for information on that.

Job 1: Delete all the empty rows. Thankfully this one’s easy. Select the entire worksheet or range of cells you’re working with, hit F5, select Special, check the box labelled Blanks and hit OK. This will select all the blank cells in the selection. From here select Edit, Delete and when prompted, select Entire Row. Alt-E then D will work in Excel 2007 as it doesn’t have an Edit menu as such. This will do exactly what it says and delete the entire row containing the selected blank cells. Be careful doing this with non-tabular data.

Job 2: Delete all the headers except the top row. Unfortunately I haven’t made this work without deleting the top row too but if you copy the top headers to a new sheet first you can easily paste them back later. In Excel 2007 hit the Developer tab (it can be enabled in Excel options if it’s not showing), click Visual Basic and add a new Module by right-clicking the top pane on the left. Paste the following code into the module that gets created:

1
2
3
4
5
6
7
8
9

Sub DeleteRows()
    Dim Rg As Range
    On Error Resume Next
    For i = ActiveSheet.UsedRange.Rows.Count To 1 Step -1
        Set Rg = Nothing
        Set Rg = Rows(i).Find("Time")
        If Not Rg Is Nothing Then Rows(i).Delete
    Next
End Sub

Change “Time” to a text pattern that will match the rows you want to delete. In the data I’m working on all the header rows have a “Time” column so this works for me.

From here it’s just a case of hitting the Run button and all the rows containing the word “Time” will be removed. Please note that in Excel 2007 you’ll need to save the file as an Excel Macro-Enabled Workbook once a file contains macros or VBA code.

Handy and much faster than deleting them manually.

Related posts:

1. Old school DOS command for file clean-up It’s time for a bit of a step back now...
2. Disable Internet Explorer Enhanced Security Configuration (IEESC) on Windows 2008 The default configuration for Windows Server 2008 still has Internet...
3. Developer “dumbness” Hmmm. Was looking at a basic console app a few...

Related posts brought to you by Yet Another Related Posts Plugin.

They’re now carrying on with PHP support by way of PDT but the features don’t seem to be anywhere near as good. It doesn’t take much looking around on Google to see that there are a lot of *very* disappointed & angry people out there in response to this, including me. As much as I dislike writing posts of a negative nature, I can’t help this one, sorry.

Related posts:

1. MSDN Library for Visual Studio 2008 fails to install At the moment I’m rebuilding my laptop (don’t ask why)....
2. Visual Studio System.Xml.XmlException when adding custom controls Ok this was just too weird to leaving without blogging....
3. Error 29506 when installing SQL Server 2005 Management Studio Express on Vista If you need to install SQL Server 2005 Management Studio...

Related posts brought to you by Yet Another Related Posts Plugin.