Blog posts

Oct 211 min read

Dynamically loading a DLL "on-the-fly"

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

Apr 114 min read

Working with files and folders in VBA

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

Nov 9, 20233 min read

Get extended properties for a file

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?

Sep 22, 20231 min read

AddIn Assistant

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

Aug 10, 20224 min read

Let the user choose a single file

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

Mar 4, 20229 min read

Installing and updating Add-ins

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

Feb 22, 20221 min read

Join two parts of a file or folder path

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

Feb 22, 20221 min read

Does a file or folder exist?

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

Feb 22, 20221 min read

Get all files in a folder

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

Articles: Blog2