Blog posts

NOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...

Code often needs to pause and wait for something else to happen. There are a number of options to do this. In Excel, you can use...

NOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...

This code uses the GetLocalTime Windows API to get a more accurate time than VBA will supply, accurate to around 15 milliseconds. You can...