/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

25 votes518 views3 answers
String to date vb
VBA
0 vote344 views1 answer
Excel vba disable keyboard input
VBA
0 vote330 views2 answers
Excel vba close without saving
VBA
0 vote352 views2 answers
Vba remove line breaks
VBA
0 vote327 views1 answer
Vba apostrophe chr
VBA
0 vote356 views1 answer
How to use if condition in time vba
VBA
0 vote338 views1 answer
Refresh token em vb net
VBA
0 vote333 views1 answer
Excel vba disable alerts
VBA
0 vote372 views1 answer
Build an index all files of a FTP site
VBA
0 vote363 views1 answer
Change form background image vb
VBA

Share