FILE NAME AS TEXT

[pipcom]

My open workbood contains a formula with a linked reference to another
workbook. I want to capture the file name as text in another cell of the
open workbook. Probably simple, but I haven't managed it.

 

[Gary''s Student]

A simple way (without using VBA) is to find an unused cell in the "other"
workbook and place the filename in it (say cell Z100). Then, in your open
workbook, put a link to Z100 in the "other" workbook.

Basically its just anticipate your need and instrument it.