VBA pull data from closed workbook depends upon header status !!! need help of experts

Dear expert's


I WANT PULL DATA FROM CLOSED WORKBOOK DEPENDS UPON
"HEADER STATUS VALUES" I HAVE SET OF HEADER VALUES "A1:P1" NOT MORE THAN THAT

I HAVE SOME MULTIPLE SLC_1,2,3,4,5 ETC WORKBOOK IN SOME TARGETED FOLDER(D:\Documents and Settings\Administrator\Desktop\FORUMINPUT\REBV\HEADERUPDATES))

...FROM THE TARGETED FOLDER I WANT PULL DATA RANGE OF A:Q IN Q COLUMN I WANT PULL WORKBOOK NAME (E.G) IF PULLED FROM SLC_1 I WANT SLC_1.XLS IN Q COLUMN

IN EVERY WORKBOOK CONTAINS SAME SET OF HEADER STATUS" BUT IT GET CHANGED INTO DIFFERENT COLUMN...

FOR E.G IN WORKING FILE SLC_1 HAVE SAME SET OF HEADER(A:P) BUT IN 15 HEADER STATUS COLUMN "CUSTOMER " MOVED TO 13

AT THE SAME TIME 13 HEADER STATUS COLUMN "CONTACT NAME " MOVED TO 15 "

I WANT PULL SAME RANGE EVEN THOUGH IN BETWEEN COLUMN HAS HIDE I WANT PULL DATA....

FIND THE ATTACHMENT WITH THREAD( ONE IS MASTER, REST 3 (SLC,1,2,3 IS WORKING FILE)

RESI;T EXPECTED IS IN SHEET2 IN MASTER)

THANKS ALOT

any experts help on my thread???

I am not sure on the speed and may be very slow, but I have tested it on the 3 sheets and works.

You need to change the path

Dude It works Perfectly With out having debugging error!!! But its not pull the data from path....

any one help on code

Please Login or Register  to view this content.

It may be this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

No dude It not working for me....even i tried in 2003 and 2007 also if you have done successfully can you upload that sheet?

What do you mean it is not working? I have tested on my PC and works. When you loop though your folder, does the code skip certain sheets? Could you run it by pressing F8 and see if it picks up all your files. Remember, the code works on a single Dir name ONLY, not sub folders.

I have added another code. I hope one of them should work for you.
The first code should work with any file xls and second works with any xl files.

Yes Its works fine and perfectly as what am i looking for !!!! Your are awesome Mr AB33... thanks alot ever keept helping me