This macro uses python shutil library to copy files between folders (and rename then if necessary). If there already are files with the same name on the destinationFile, it will overwrite them.
Input Example
sourceFile | destinationFile |
G:\test\Template.xlsx | G:\test\Output\AUSTRALIA.xlsx |
G:\test\Template.xlsx | G:\test\Output\CANADA.xlsx |
G:\test\Template.xlsx | G:\test\Output\CHINA.xlsx |
The macro is embedded in an example case that needs the copy of a excel template for different countries of the dataset, and keep the formatting for each one of them.