Displaying information from 2 directories

[Harshinee]

Dear all ,

I already retrieve data by reading them from a file H:\bursa\Programming\FSA_SOD which need to display in column A (the date in column A is from file name with format of yyyymmdd and display as column A in the format of dd-mmm-yyyy ) and in column E , I already display value of U50 from all the files according to the file name. The files are in the FSA_SOD folder.

Now I need to get data from H:\bursa\Programming\Investment Maturing where all the excel files are in the Investment Maturing folder and file names are in the format of ddmmyyyy.This format must also change into dd-mmm-yyyy like above and need to extract data from cell E26 from all the files according to the file name and display it in column D.

Below I have attach 2 files..the initial file is the one that Im working on it now and expected output is what I want to see.

This is the code that gives output on the initial file. Can anyone kindly edit the code so that I can see the output in the expected file.xlsx. Thank you..

Please Login or Register  to view this content.

[Fotis1991]

Can you pls explain which is the difference from this-your own thread?

http://www.excelforum.com/excel-prog...ml#post3533507

[Harshinee]

Yes, its exactly the same question.. and I am helping my friend out.. since the earlier post has no reply...she ask for my help... so that there would be other person who can solve this question...So my friend needs your help, can you solve it or give some guidance to solve this code ? Thanks..

[Fotis1991]

I am really sorry but according forum rules.....

Unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.