Custom footer will not print from Macro

[sbuca76]

I have recorded a macro in Excel 2010 which contains, as part of it, inserting a custom footer, specifically the file name. When the macro is run, the filename disappears even though the macro code shows the center footer containing the code "&F". Is this a bug or is there an update for it?

 

[sbuca76]

Has anyone had this issue with macros?

 

[jae113]

I was having the same problem. I found this workaround on Microsoft's site

In place of your VBA code that gets recorded, in the appropriate footer or header section do the following (hit ALT+F11 to get to the VBA editor and open the Module on the left side that was created):
To show the current page number replace &P with &P[]
To show the number of pages in your workbook, replace &P with &N[]
To show the current date, replace &D with &D[]
To show the current time replace &T with &T[]
To show the file path replace &P or whatever got recorded with &Z[]
To insert the current file name replace &F with &F[]
To insert the sheet name replace &Tab with &A[]

 

[jae113]

I just found a better way to make this work. PrintCommunication is new to 2010 (maybe 2007 too, I don't know) and it will come up in your macro, especially if you use the recorder.

Remove all Application.PrintCommunication, it can be true or false, from your macro.

Headers and Footers should work fine!

The macros do work a little slower, but it seems ok