/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

1 vote171 views1 answer
Excel format cell as kilowatts
VBA
31 votes219 views1 answer
Vba how to convert a column number into an Excel column
VBA
3 votes175 views1 answer
Vba folderexists
VBA
0 vote189 views1 answer
Vba sort the data Z to A
VBA
0 vote167 views1 answer
Compare dates vb
VBA
0 vote170 views1 answer
Vba change named range address
VBA
0 vote150 views1 answer
Excel autofilter vba
VBA
0 vote162 views1 answer
How to get the value of optionbutton in vba
VBA
1 vote185 views1 answer
How to remove zeros in excel
VBA
0 vote178 views1 answer
Get current url vb.net
VBA

Share