/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 vote219 views1 answer
Random number generator vb.net
VBA
0 vote321 views2 answers
VB
VBA
0 vote237 views1 answer
Return na vba
VBA
0 vote224 views1 answer
Openfiledialog specific folder
VBA
0 vote229 views1 answer
Returns an array from function vba
VBA
0 vote225 views1 answer
Show unix time in vba
VBA
1 vote210 views1 answer
How to do error handling in access vba
VBA
5 votes245 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote215 views1 answer
Excel vba range contains
VBA
1 vote207 views1 answer
Vba compile error object required
VBA

Share