Be the first user to complete this post
|
Add to List |
FileSystemObject : FolderExists Method
Description:
Returns True if a specified folder exists; False if it does not.
Format :
objectOfFileSystemObject. FolderExists(foldername)
Arguments:
- objectOfFileSystemObject
- As the names says, it’s a FileSystemObject.
- foldername
- Mandatory
- Type: String
- Folder , whose existence to be determined.
Function FnIsFolderExist(strCompleteFolderPath) Set fso = CreateObject("Scripting.FileSystemObject") If fso. FolderExists(strCompleteFolderPath)Then strStatus = strCompleteFolderPath & “ folder exists” Else strStatus = strCompleteFolderPath & “ folder does not exist” End If FnIsFolderExist = strStatus End Function
Msgbox FnIsFolderExist ("c:\New Folder")
Also Read:
- Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
- VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
- FileSystemObject : GetParentFolderName Method
- FileSystemObject : CreateFolder Method
- FileSystemObject : DriveExists Method