Forum Discussion
Remove File Extension in Custom Header in an Excel Sheet
When I insert file name as using &[File] in the custom header, the file extension ".xlsx " also gets added & printed. How can I display & print an Excel sheet without file extension?
aredev I know I'm late to the party and you've already forgotten that you had this problem at one time, but I'm really posting for others who may be searching for this issue, as I was today. If you want the file name in the header, you could use the file name as the sheet name (without the extension) and then use the sheet name as your header. Much easier. The use of the marco is way above my pay grade. Ms. Hawighorst's answer is extremely knowledgeable, and I wish I could maneuver Excel like she clearly can. Hat's off to her. However, for the plebes who aren't at that level, this will work wonders.