=cell("filename")

[Jim, Lima, OH]

When I use the above function with more than one Excel File open, then both
files end up with the same file name.

I live with more than one file open, and I am constantly going back & forth
correcting the file name. Is there any way to get the file name & path in
the cell for each specifice Excel file?

Do you understand my question??

 

[Gary''s Student]

=CELL("filename",A1)

 

[Jim, Lima, OH]

What are you saying? Simply add ,A1 to the string? Talk to me!

 

[Gary''s Student]

yes
--
Gary''s Student - gsnu200783

What are you saying? Simply add ,A1 to the string? Talk to me!

 

[Jim, Lima, OH]

Gary:

From a "non-techie," I say thank you!

yes