Insert first row in multiple excel files in given folder
Posted on 2013-01-25
I would like to run a macro that performs the following action:
I got hundreds of xlsm-files in C:\temp\
- I would like to insert a row at the very top of each workbook (each workbook contains just one worksheet named 'temp').
- This newly created first row has to have the following entries for A1, B1, C1, D1:
Item Number, Customer, Street, Items.
- The first row should be formatted to repeat with each page break (rows to repeat at top)
Help is much appreciated. Thank you very much in advance.