Most recent articles
Compact and Repair Access Databases by Searching Directories and Sub-Folders
At some point in time most programmers are faced with a task where they need to recursively search through filesystem folders and perform some sort of operation on matched files. For VBA programmers in Access, this “operation” often involves the compaction and repair of .mdb and .accdb files in order to free up disk space on the filesystem.
Parsing a File String Into Path, File Name, and Extension
Merging Multiple Workbooks Together by Searching Directories and Sub-Folders
At some point in time most programmers are faced with a task where they need to recursively search through filesystem folders and perform some sort of operation on matched files. For VBA programmers in Excel, this “operation” often involves the merging of matched .xls and .xlsx files together into a single Workbook.