You don't mention which file you want to get. I am assuming you want the path
of the file running the code...

Range("A20").Value = ThisWorkbook.FullName
If you want the user to browse for the file then try
Range("A20").Value = application.Getopenfilename
--
HTH...

Jim Thomlinson


"HappySenior" wrote:

How can I record in cell A20 on sheet 1, the full path of a file?

I misunderstood a previous post which seeks to open a file by reading
a ws cell.

Don in Montana