/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 vote346 views1 answer
How to make a if statement with vbs
VBA
1 vote356 views1 answer
Excel date to unix timestamp
VBA
0 vote370 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote372 views1 answer
VBA Loop to range
VBA
0 vote298 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote405 views1 answer
Open file dialog in vb.net
VBA
0 vote376 views1 answer
Excel protect cells with formulas
VBA
0 vote394 views1 answer
Loop through lines in text file vb net
VBA
0 vote403 views1 answer
Vba boolean to string
VBA
0 vote359 views1 answer
Handling a click event anywhere inside a panel vb
VBA

Share