I have tried all night and day to solve this problem.

I have a main excel file for the results and approximately 500 excel names in acolumn in that main excel. In another folder a have nearly 300 excel files. What I want to do is:

1-Read the first cell (in the main excel) that is (cell: "B3").

2-Find the file named ("B3"=ADANA) in 'E:\BIST\DATA\FINANSALLAR\2009-12\("B3").

3-Open that excel file.

4- Search for a string named "NÜFUS".

5- Take the third column value written near "NÜFUS" word. (VLOOKUP?)

6- Copy the value to the main excel cell: "C3"

7-Save main excel.

8- Read the next cell (in the main excel) that is (cell: B4)

9-Find the file named ("B4"=ANKARA) in 'E:\BIST\DATA\FINANSALLAR\2009-12\("B4").

10- Open the file named B4.

11-Close the file named B3.

12- Search for the same string named "NÜFUS".

13-Take the third column value written near "NÜFUS" word.

14- Copy the value to the main excel cell: "C4"

.... This will continue for 500 excel cells in the main excel. End up in B503.

I appreciate for your helps. I found many links and tried most of them but I am lost.

Thank you...