I have a form that have a field as "txtTarget" which save the destination path of file. I want to split the path and just save the require as For example: file path is (W:\GLO\ALL\...) , it should be save in table as (\GLO\ALL\EXMP1.pdf...) OR (\ABC.pdf), the drive name which is c:\ or D:\ should not be saved. In my code i have written code as
Me.txtTarget = Split(TargetFile, "\", 1)(0)
for splitting but it's not working as required.
Also if anyone can also guide how to concatenate that back afterwards when require to open this file would be helpful.