Variabeler

A = "C:\Data\Undermappe\2 undermappe\test.txt"

B = split(A,"\")(ubound(A))

snarere sådan
A = "C:\Data\Undermappe\2 undermappe\test.txt"
B = Right(A, Len(A) - InStrRev(A, "\", Len(A)))

Function GetFilenameFromPath(ByVal strPath As String) As String
' Returns the rightmost characters of a string upto but not including the rightmost '\'
' e.g. 'c:\winnt\win.ini' returns 'win.ini'
   
    If Right$(strPath, 1) <> "\" And Len(strPath) > 0 Then
        GetFilenameFromPath = GetFilenameFromPath(Left$(strPath, Len(strPath) - 1)) + Right$(strPath, 1)
    End If
End Function

A = "C:\Data\Undermappe\2 undermappe\test.txt"
B = Right(A, Len(A) - InStrRev(A, "\", Len(A)))
Lader til at kunne gøre jobbet...

Jeg tror jeg for behov for at seperere "test" i en variabel og filextension ".txt" i en anden, hvordan krignler jeg den?

A = "C:\Data\Undermappe\2 undermappe\test.txt"
b = Right(A, Len(A) - InStrRev(A, "\", Len(A)))
C = Split(b, ".")(0)
D = Split(b, ".")(1)