Write filepath to file
 

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

Write filepath to file
 

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

Write filepath to file
 

On Sep 22, 4:45*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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- Hide quoted text -

- Show quoted text -

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