Melbourne based again as at the start of March 2009.

Linkedin Profile @ http://www.linkedin.com/profile?viewProfile=&key=2996376.
My free "The Duplicate Master" addin for Excel (2000 or higher) has found a new home at Bob Phillip's site, http://xldynamic.com/source/xld.DupMaster.html
My Excel KB articles at VBAeXpress can be found at http://vbaexpress.com/kb/default.php

My favourite questions typically involve automating Outlook, Word or Internet Explorer from Excel, plus of course the occasional regular expression

Excel VBA: http://www.experts-exchange.com/Q_24159183.html
1.      searches the Outlook inbox for the latest message from a specific user,
2.      using a Regexp to parse the first internet hyperlink in the email,
3.      opens this hyperlink vie Internet Explorer,
4.      and then creating Excel hyperlinks to all the downloadable excel files at the link.

Outlook VBA: http://www.experts-exchange.com/Q_24162610.html
1.      prompts the user to select a folder,
2.      loop through each mailtem,
3.      use a Regexp to remove all the blank lines,
4.      write each edited mail item to a text file,
5.      modify the final text file with Word and then print out all the emails in a concise file.

Excel VBA: http://www.experts-exchange.com/Q_23787032.html
1.      Setup a master list of number codes in the first sheet,
2.      Loop through each of these numbers and identify with a Regexp if these numbers are used in any other sheet formulas,
3.      If these numbers are found, navigate recursively through all cell dependents,
4.      Check if any of these dependents end up being used on a specific sheet,
5.      Finally identify any numbers from sheet1 that are not eventually references on that specific sheet.


VBA or VBscrip: http://www.experts-exchange.com/Q_Q_24593416.html
Convert a list of multiline addresses into a list of single line addresses
1.      Open a text file and parse consecutive text lines into a single line, making blank lines into carriage returns
2.     Write the new test into an array, then loop through the array and write each record to a new text file
3.     The final product can be imported into Excel as a list of single cell addresses

Cheers
Dave