Updating footer image for all excel files

[han0990]

Hi all, may I ask if it's possible to update the footer for all of the excel file at once? I have 100+ excel files that are currently using an old certification logo for the footer. It will be extremely tedious to update every single files manually. Is there a way to automate the entire process?

Thank you.

[#2]

@han0990 

For a workbook with many worksheets:
If you select all worksheets and then define the headers via File - Page setup, this header applies to all worksheets.

If you want to change footer for many workbooks, you would need to use VBA code.

Here is a small VBA example (untested):

OptionExplicit

Const strPath As String = "C:\test\" ' with a \ at the end !!!

sub x()
    Dim strFile As String
   
    strFile = Dir(strPath & "*.xls")
    While strFile <> ""
       Workbooks. Open strPath & strFile
       Call YourMacro
       ActiveWorkbook.Close True
       strFile = Dir
    turn
end sub

Sub YourMacro()
    ' recorded macro
end sub

NikolinoDE