Posts

  • How to tell if a file is a Word document

    I am building a tool that needs to do something to all the Word documents in a set of folders. There are other sorts of files in these folders so I need to filter the...

  • Handling strings containing quotes in SQL

    Everyone is aware that quotes in strings used in SQL cause all sorts of problems. As developers, it is our duty to ensure that an end user never sees an SQL error because we didn’t...

  • Understanding the INDIRECT function in Excel

    This is not a VBA issue but a recent discussion on LinkedIn brought up the question of how to use INDIRECT to construct a reference to a named range in an external sheet. I have...

  • Microsoft Project holiday import wizard

    Check out this VBA enabled Microsoft Project Plan document that I recently developed. It neatly solves a need of every project manager who uses Microsoft Project to track their project: marking public holidays as...

  • Error in Excel 2007 workbooks open method

    I have discovered a disturbing “feature” in Excel 2007 VBA in the way that the Workbooks.Open method handles xlsx format files versus the legacy xls format file. If a file has a “workbook protection” password...

  • 2008 Super Fund Performance

    Unfortunately, and as predicted last year, Bainsworld Superannuation Fund had a negative return of -17.3% for 2008. Whilst not unexpected and probably reasonable given the carnage on the share market, it is nonetheless disappointing. However,...

  • Is that file open?

    If you ever need to determine if a file is already open before you attempt to do something with it in VBA, you will discover a bewildering array of code segments on the interweb which...

subscribe via RSS