ExcelBanter - Paste file name into cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Paste file name into cell (https://www.excelbanter.com/excel-discussion-misc-queries/60445-paste-file-name-into-cell.html)

JulieK

Paste file name into cell

I am trying to have Excel automatically paste the file name into a cell - I
don't want to use the header or footer for this. Thanks, Julie

Vito

Paste file name into cell

Try:

=CELL("filename")

--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493604

Gord Dibben

Paste file name into cell

Julie

See Bob Phillips' site for this.

http://www.xldynamic.com/source/xld.xlFAQ0002.html

Gord Dibben Excel MVP

On Wed, 14 Dec 2005 13:47:47 -0800, JulieK
wrote:

I am trying to have Excel automatically paste the file name into a cell - I
don't want to use the header or footer for this. Thanks, Julie

All times are GMT +1. The time now is 02:24 AM.