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.
--
Gary''s Student - gsnu200791


"pipcom" wrote:

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.