Apply page setup setting to other workbooks
I am looking for a method to apply page setup settings (header, footer, and all other page print setups) to other workbooks (not sheets in the current workbook).
I have the setting I need in a file (excel template or other excel file).
Some other SW tool is automatically generating reports in excel file format (new workbooks).
I need a method to apply the page settings to the new workbooks (and not to do it manually to each of them)
I am looking for same method that can apply a customized default page setup to any workbooks in the print page.
So far, I saved a template so when I open a new workbook with that template, I can print the way I set it up. But I still have to manually choose to open the template or set up the page if I want to print an old workbook that wasn't saved with the template.
I need a customizable default page setup simply apply to any workbook/sheet when printing