/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 vote183 views1 answer
Vba remove last vbcrlf
VBA
0 vote168 views1 answer
Enter into cells data grid view
VBA
1 vote192 views1 answer
Vba optional
VBA
0 vote184 views1 answer
Create links in msgbox in vb
VBA
0 vote224 views1 answer
Visual basic run command
VBA
8 votes266 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote177 views1 answer
Vba collection contains
VBA
0 vote189 views1 answer
How to add line graph vb net
VBA
4 votes189 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote220 views1 answer
Vba ternary
VBA

Share