/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 vote317 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote334 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
1 vote298 views1 answer
Excel vba last column in range
VBA
0 vote300 views1 answer
Send text to clipboard vb.net
VBA
1 vote278 views1 answer
Close form vba
VBA
0 vote282 views1 answer
Vb net dgv doesn't keep currency format
VBA
-1 vote312 views1 answer
How save excel through visual basic
VBA
0 vote308 views1 answer
Excel vba protect sheet
VBA
0 vote310 views1 answer
How to enter Vbox manage commands
VBA
0 vote299 views2 answers
Open url from vba
VBA

Share