As mentioned in the title, the code below is for checking if a file exists in a certain directory. I find this function useful for monitoring if drawings have been created and are ready for production.
Public Function InFolder(Folderpath As String, Filename As String, FileExtension As String) As Boolean 'Infolder returns TRUE if a file is found in the specified folderpath 'Add backslash (\) to end of folderpath if there isn't one If Right(Folderpath, 1) <> "\" Then Folderpath = Folderpath & "\" End If 'Add period (.) to front of file extension if there isn't one If Left(FileExtension, 1) <> "." Then FileExtension = "." & FileExtension End If 'Create filepath from input arguments Filepath = Folderpath & Filename & FileExtension 'Check if file exists If Dir(Filepath) <> "" Then InFolder = True Else InFolder = False End If End Function
You can either save this directly in your current workbook or if you’d like the function available in all workbooks, save it to a AddIn file (.xlam) in the default folder and enable the AddIn through File>Options>AddIns>Go.
If you are typing arguments in directly, then you will need quotes. However, if you are referencing other cells as input, quotes are unnecessary.