FILE NAME AS TEXT

P

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.
 
G

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.
 
Top