/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

0 vote131 views1 answer
Excel delete ever other vba
VBA
0 vote123 views1 answer
Vba clear collection
VBA
6 votes121 views1 answer
Excel vba get the path of current workbook
VBA
0 vote119 views1 answer
Vb streamreader
VBA
0 vote120 views1 answer
Vbnet check if string is only symbols
VBA
1 vote130 views1 answer
Vb.net get name by Cell Click
VBA
5 votes131 views1 answer
Excel vba low word from Long Integer
VBA
0 vote136 views2 answers
Vb.net include quotes in string
VBA
1 vote115 views1 answer
Vba declare api 64 bit 32 bit
VBA
4 votes112 views1 answer
Excel formula for last non-empty cell in a column
VBA

Share