/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 vote294 views1 answer
Ms access open form to new record
VBA
4 votes332 views2 answers
Vba create folder if not exist
VBA
1 vote327 views1 answer
How to open cmd with vbd
VBA
1 vote343 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote340 views1 answer
Excel vba last column in range
VBA
8 votes448 views1 answer
Excel vba make word
VBA
1 vote339 views1 answer
Excel vba saveas force overwrite
VBA
0 vote328 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote349 views1 answer
Vba add shape oval
VBA
0 vote335 views1 answer
Freeze panes vba
VBA

Share