I would like to run a macro with the following requirements:
Copy the first row (header row with column captions) of the file 'MyHeaderFile' located in D:\MyData\MyHeaderFile.xls and ...
... batch insert that row as header row into all excel-files located in D:\MyExcelFiles\
Help is much appreciated.
Thank you very much in advance.