/VBA/Vba check if file exists

Vba check if file exists

Excel vba check if directory exists

Public Function IsDir(s)
    IsDir = CreateObject("Scripting.FileSystemObject").FolderExists(s)
End Function

22

Source: academy.excelhero.com

Vba check if file exists

Public Function IsFile(s)
    IsFile = CreateObject("Scripting.FileSystemObject").FileExists(s)
End Function

5

Source: stackoverflow.com

Similar codes

3 votes126 views1 answer
Vba make long from two shorts
VBA
2 votes142 views2 answers
Excel vba if sunday or staurday
VBA
-1 vote149 views1 answer
How save excel through visual basic
VBA
0 vote121 views1 answer
Vba border weight
VBA
0 vote123 views1 answer
Hello world vb.net
VBA
0 vote127 views1 answer
Excel vba hide gridlines
VBA
2 votes122 views1 answer
Vba split string
VBA
0 vote121 views1 answer
Vb get ip address
VBA
0 vote128 views1 answer
Windows Forms dark title bar
VBA
0 vote122 views1 answer
Remove first character from string vb
VBA

Share