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?
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?