Excel iconVBA icon

List matching folders in a directory

The following function will return a comma delimited list of folders one level below the specified folder. For example, if you needed to fill a listbox or worksheet with a list of matching folder names. The code assumes that you do not use commas in your folder names.

Continue Reading: List matching folders in a directory »

Excel iconVBA icon

Take advantage of Intellisense when writing late bound code

Many people are familiar with the page on binding found on Dick Kusleika's website "Dick's Clicks" which advises the following:

To get the most out of the VBA development environment and still write robust code, you should write the code early bound, but change it to late bound before distributing it. Even if you write it for personal use only, it makes sense to convert it to late bound. Someday you will have a different computer or send it to your brother and it won't work because they will have an earlier version. If you're a die-hard procrastinator like me, you will be cursing yourself for not converting to late bound sooner.

Continue Reading: Take advantage of Intellisense when writing late bound code »

Site last updated: February 9, 2012