/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

1 vote281 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote292 views1 answer
String contins in vba
VBA
0 vote317 views1 answer
Style percent not found vba
VBA
0 vote285 views1 answer
Vba sort multiple columns
VBA
0 vote316 views1 answer
Get month number from month name vbnet
VBA
0 vote278 views1 answer
Excel vba disable mouse click
VBA
0 vote312 views1 answer
Create links in msgbox in vb
VBA
4 votes299 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote309 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote286 views1 answer
Excel vba autofit
VBA

Share