/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

3 votes145 views1 answer
Excel vba make long from two shorts
VBA
0 vote126 views1 answer
Remove series name from legendvbnet
VBA
1 vote135 views1 answer
Add rows to datagridview vb.net
VBA
1 vote126 views1 answer
How to put a gridpain in a vbox
VBA
5 votes120 views1 answer
Excel vba how to unit test vba code
VBA
-1 vote127 views1 answer
Vba code to add new column in table
VBA
2 votes114 views1 answer
Vba uppercase first letter of each word
VBA
0 vote75 views1 answer
How to make a if statement with vbs
VBA
0 vote123 views1 answer
Make your computer talk vbscript
VBA
3 votes133 views1 answer
Excel insert blank row for value change in column
VBA

Share