If all you want is the filename at the end, I'd just use Split:
![]()
Dim strFile as String, varData varData = Split(Worksheets("Sheet1").Range("A1").Value, "\") strFile = varData(Ubound(varData))
If all you want is the filename at the end, I'd just use Split:
![]()
Dim strFile as String, varData varData = Split(Worksheets("Sheet1").Range("A1").Value, "\") strFile = varData(Ubound(varData))
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks