how to insert filename in header without file extension
 

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

how to insert filename in header without file extension
 

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.



"Andrew King" wrote:

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

how to insert filename in header without file extension
 

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



"trip_to_tokyo" wrote:


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.



"Andrew King" wrote:

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

how to insert filename in header without file extension
 

OP does not want file path and filename.

Filename only without the extension.


Gord Dibben MS Excel MVP

On Mon, 11 Jan 2010 21:15:01 -0800, trip_to_tokyo
wrote:


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.



"Andrew King" wrote:

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

how to insert filename in header without file extension
 

My ComputerToolsFolder OptionsView

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
wrote:

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