how to insert filename in header without file extension

[Andrew King]

I'm looking for a way to insert the filename in a header without also
including the file extension. The header button in Excel inserts both with no
option to exclude the extension. I can write a macro but really just looking
for an automatic option. Thanks, Andrew

 

[trip_to_tokyo]

This works for me in EXCEL 2007:-

Page Layout

Page Setup group

Click on the arrow in the lower right hand corner. Page Setup should launch.

Header / Footer

Custom Header. . .

Click in the:-

Right section:

- in the lower right hand corner.

Click on the Insert File Path icon.

OK and OK again.

Print the single page and it will have the file path in the lower right hand
corner.

Please hit Yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

"Print the single page and it will have the file path in the lower right hand
corner."

- sorry, above should read upper right hand corner. Apologies.

 

[Gord Dibben]

OP does not want file path and filename.

Filename only without the extension.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

My Computer>Tools>Folder Options>View

Enable "hide extensions for known file types"

Or a macro.


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 20:33:01 -0800, Andrew King <Andrew