/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
Vba horizontalalignment
VBA
1 vote260 views1 answer
Vbscript convert ascii code to character
VBA
0 vote271 views1 answer
Vlookup columns not next to each other
VBA
0 vote273 views1 answer
Excel vba range contains
VBA
0 vote287 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote285 views1 answer
Excel vba remove formatting from cell
VBA
0 vote271 views1 answer
Vba paste values
VBA
0 vote276 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote270 views1 answer
Vba code to select image in sheet
VBA
0 vote266 views1 answer
Vba file size
VBA

Share