'Reusable function to check if a file exists Function DoesFileExist(filePath) As Boolean When regularly checking for the existence of files, it can be easier to have a reusable function within a Module to be called upon when required. If Dir(filePath) "" Then 'Insert action for if the file exists 'This example displays a message boxĮlse 'Insert actions if the file does not exist 'This example displays a message box Sub PerformActionIfFileExists()įilePath = "C:\Users\marks\Documents\Folder\FileName.xlsx" The code below uses an If statement to carry out different actions depending on if the file does or does not exist. MsgBox Dir("C:\Users\marks\Documents\Folder\Text.xlsx") "" The code below will display True or False in a message box to indicate if the file exists. As a result, checking for a file’s existence can be one of the most common action we perform. If any actions are performed on a file that does not exist, the VBA code will error.
0 kommentar(er)
