×

Files/Folders

VBA Code To Select A Folder Path

VBA Code To Select A Folder Path

What This VBA Code Does This VBA code will show you how to allow your user to select a folder...

VBA Code To Validate A File Path

VBA Code To Validate A File Path

What This VBA Code Does This VBA function will accept a file path text string and confirm if the file...

VBA Function To Validate (Test) A Given PowerPoint File Name

VBA Function To Validate (Test) A Given PowerPoint File Name

What This VBA Macro Code Does When you ask your users to supply a file name during your VBA automation,...

VBA Code To Find And Replace Words Within Specific File Names In A Folder

VBA Code To Find And Replace Words Within Specific File Names In A Folder

What This VBA Code Does I often have a routine of copying files from one month to another. The only...

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

What This VBA Code Does I often find myself needing to set up monthly folders for routine reports. Instead of...

VBA Function To Determine If An Excel File Name Is Valid

VBA Function To Determine If An Excel File Name Is Valid

What This VBA Macro Code Does I've written a few macros over the past few days that have required the...

Loop Through All Excel Files In A Given Folder

Loop Through All Excel Files In A Given Folder

What This VBA Code Does This VBA macro will let you select a folder path and loop through each of...

Retrieving The File Name & Extension From A File Path String

Retrieving The File Name & Extension From A File Path String

What This VBA Code Does This macro will show you how to manipulate a file path in order to extract...