/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 vote344 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote297 views1 answer
Vba format currency
VBA
4 votes376 views1 answer
VBA Deep Clone Dictionary
VBA
9 votes453 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote319 views1 answer
Excel text to columns line break
VBA
0 vote307 views1 answer
Vbscript abs
VBA
0 vote287 views1 answer
Excel vba milliseconds
VBA
0 vote318 views1 answer
Worksheet.pastespecial textbox
VBA
5 votes360 views2 answers
Excel vba write to the windows registry
VBA
0 vote306 views1 answer
Vb net check if file exists
VBA

Share