/VBA/Excel vba extract file name

Excel vba extract file name

Excel vba extract file name

Dim path As String
path = "C:\Temp\data\myfile.txt"
Debug.Print Mid$(path, InStrRev(path, "\") + 1)    ' -> myfile.txt

2

Similar codes

0 vote290 views1 answer
How to self delete a vbscript file
VBA
0 vote332 views1 answer
Vba find sub dictionary
VBA
1 vote345 views1 answer
How to remove zeros in excel
VBA
9 votes474 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
1 vote329 views1 answer
Add control vb
VBA
0 vote321 views1 answer
Vba argument is set
VBA
0 vote358 views1 answer
Excel vba protect shapes
VBA
2 votes323 views1 answer
Excel vba date to string conversion
VBA
0 vote324 views1 answer
Vb streamreader
VBA
0 vote333 views1 answer
Vba collection key list
VBA

Share