Blog posts

Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.

Working with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler

It's fairly straight-forward to get the basic properties for a file, but how do you get the extended properties for a file with VBA?

Need help with installing an AddIn in Excel, Word, PowerPoint or Outlook? Get the AddIn Assistant!

A common requirement for VBA macros is to let the user choose a file, often the file will have some data that the macro is to work with,...

Installing and updating an Add-in for an Office application is not difficult. Honest, it's not. But the right steps have to be performed...

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'...

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'...

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'...