/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

0 vote276 views1 answer
Convert unix to date vba
VBA
13 votes380 views2 answers
Vba write text file
VBA
0 vote276 views1 answer
Make all controls in an area not visable vb
VBA
0 vote288 views1 answer
Vba cell all borders
VBA
1 vote275 views1 answer
Add a index column power bi
VBA
2 votes271 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote277 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote297 views1 answer
Vba search string position
VBA
0 vote281 views1 answer
Excel vba join variant array
VBA
1 vote294 views1 answer
Vba format string as cash
VBA

Share