| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILE NAME AS TEXT
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FILE NAME AS TEXT
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
