Write filepath to file

[HappySenior]

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

 

[Jim Thomlinson]

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

 

[HappySenior]

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







- Show quoted text -

Jim,
You assumed correctly. ThisWorkbook.FullName us exactly what I wanted.
Many Thanks
Don