/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 vote118 views1 answer
Type excel.application is not defined vb
VBA
0 vote160 views1 answer
How to call gcd in vba
VBA
0 vote125 views1 answer
Remove last 8 characters from string vb
VBA
0 vote139 views1 answer
Excel vba protect scenarios
VBA
3 votes131 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
1 vote119 views1 answer
Excel vba make cell visible
VBA
0 vote116 views1 answer
Make all controls in an area not visable vb
VBA
4 votes132 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote157 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote119 views1 answer
Check range is in another range vba
VBA

Share