/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 vote287 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote280 views1 answer
Quit excel with save changes dialog vb.net
VBA
22 votes429 views1 answer
Excel vba check if directory exists
VBA
0 vote279 views1 answer
Vb test if reference is null
VBA
5 votes328 views1 answer
Excel vba right word from Long Integer
VBA
0 vote284 views1 answer
Remove first character from string vb
VBA
0 vote310 views1 answer
Add text to combobox drop down vb
VBA
0 vote280 views1 answer
Vba pass named range to function
VBA
0 vote295 views1 answer
Excel run macro every 5 minutes
VBA
0 vote293 views1 answer
Vba collection key list
VBA

Share