Create Folders and Files Automatically

How to create folders and files automatically using VBA. Watch the video below: Here’s the complete VBA code to create the folder and files quickly and easily: Option Explicit Sub CreateNewFolderAndFile() Dim strFolderName As StringDim strFolderExists As String strFolderName = “C:\CreateFolder\”strFolderExists = Dir(strFolderName, vbDirectory) If strFolderExists = “” ThenMsgBox “The folder doesn’t exist!”MkDir strFolderNameMsgBox “New […]