Question : excel vba extract file name
Answered by : vastemonde
Dim path As String
path = "C:\Temp\data\myfile.txt"
Debug.Print Mid$(path, InStrRev(path, "\") + 1) ' -> myfile.txt
Source : | Last Update : Sat, 20 Feb 21
Answered by : vastemonde
Dim path As String
path = "C:\Temp\data\myfile.txt"
Debug.Print Mid$(path, InStrRev(path, "\") + 1) ' -> myfile.txt
Source : | Last Update : Sat, 20 Feb 21