/VBA/Excel vba folder exist

Excel vba folder exist

Excel vba check if directory exists

Public Function IsDir(s)
    IsDir = CreateObject("Scripting.FileSystemObject").FolderExists(s)
End Function

22

Source: academy.excelhero.com

Excel vba folder exist

If Dir("C:\Temp\xxx", vbDirectory) = "" Then
    MsgBox "Doesn't exists"
End If

3

Similar codes

8 votes209 views1 answer
Run command pormpt in background windows
VBA
0 vote182 views1 answer
Find the name of the last excel sheet vb
VBA
22 votes262 views1 answer
Excel vba check if directory exists
VBA
3 votes212 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote196 views1 answer
Excel vba scroll to cell
VBA
0 vote195 views1 answer
Vba format currency
VBA
3 votes203 views2 answers
Vba active workbook path
VBA
0 vote197 views1 answer
Vba word open document read only
VBA
0 vote211 views1 answer
Vba nested dictionary
VBA
0 vote204 views2 answers
Get excel file from email attachment in vba
VBA

Share