Write filepath to file

H

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
 
J

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
 
H

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 -
Click to expand...

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