Changing An Absolute Path To A Relative Path

hello

i am running a VBA script which updates cells of all files in a given folder:

   Dim myPath As String
   Dim objFso As Object
   Dim myFolder As Object, myFile   As Object
   myPath = Range("A19") 
   Set myFolder = objFso.GetFolder(myPath).Files
   For Each myFile In myFolder
      Set wb = Workbooks.Open(myFile)

in A19, i am defining the path: i.e. C:\Documents\Files\Test

however, this is an absolute path. let's say, the document which executes the macro is located in "Files", i just want to write "\Test", instead of entering the whole absolute path. Or let's say i want to update the cells in the folder above, i would like to write "..\"

does anyone have some hints or tips on how to achieve this?
any help would be very very much appreciated!