Set file name in Header without extension

[Sweeti]

Hello everybody,

I have this code in VBA:
Ws.PageSetup.RightHeader = "&F" & vbCr & "Sweeti"

This code work, but I need to have the file name without the extension.
Also I wish to set the font/size/color for the first line and I don't know how to insert in the above code without errors.

Can you help?

 

[Sweeti]

​

An easy way : activate the Macro Recorder and set the header manually in order to get the generated code according to your will …​

Great! All solved!

Thanks a lot !!!