Andreas Hermle
asked on
Batch insert copied header row into numerous excel files in a folder using VBA
Dear Experts:
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.
Regards, Andreas
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
... 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.
Regards, Andreas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
as always, works just perfect. Thank you very much for your superb and professional help. I really appreciate it.
Regards, andreas