Header add into multi excel file by VBA

[faizan haq]

Hi,

I have Header value in C1:C10 in master 1 file with file name and i need to add header one by one value into multiple files which is available in folder it should be done by VBA automatic,
please also not header all are same. you can use one.

all work on sheet1
step
1. copy (C1) value from master file
2. open 1 file from folder
3. set on centre bottom header
4. close
5. copy (C2) value from master file
6. open 2 file from folder
7. set on centre bottom header
8. close

code	file name	Header
GP01	F1925M082.xlsx	7467 ADIDAS PROJECTION - 3 (BATCH#79249 ) (080720 9-58 am)
GP02	OIS21250600.xlsx	7467 ADIDAS PROJECTION - 3 (BATCH#79249 ) (080720 9-58 am)
GP03	OIS21250931.xlsx	7467 ADIDAS PROJECTION - 3 (BATCH#79249 ) (080720 9-58 am)
GP04	OJS19250800.xlsx	7467 ADIDAS PROJECTION - 3 (BATCH#79249 ) (080720 9-58 am)

 

[faizan haq]

Hi,

please help urgently.
thanks....

 

[faizan haq]

any one can response????

 

[faizan haq]

any one can update?