Displaying file name and its info from a cell

[Harshinee]

Dear All,
Nice meeting you all, i am quite new to VB.So hope you all give me some guidance to solve this problem.

Need help from u guys , ya .I have quite a number of files with file name in the format of yyyymmdd . So, I need to create a new file to display all the dates in the first column and find a particular cell's value (for eg Excess Fund =200,000 in U50) in each file and display them in second column (column name : Excess Fund) according to their file name. I have also uploaded 2 files for reference purpose but I have more files than that.How to code this?

Thank you

 

[Hui]

Harshinee

Firstly, Welcome to the Chandoo.org Forums

Not really sure what your after but
=[20131101.xls]Report!$U$50 will retrieve the value for you

or you can use the file name as part of a formula like
=INDIRECT("["&A3&".xls]Report!"&B3)
where A3 has 20131101
and B3 has U50

 

[oldchippy]

Hi Harshinee,

Welcome to the forum, if you haven't read the rules of the forum yet, please take some time out to do it, you can start here

http://chandoo.org/forum/forums/new-users-please-start-here.14/

With regard to your files, for some reason I cannot open them, please can you open your files and save them again and re-post them with a different name.

@Hui... how come I can't open them?

 

[oldchippy]

This is what I get???

 

[Hui]

Old Chippy,
Just press Yes

 

[oldchippy]

Thanks Hui... I didn't know whether to trust that

 

[dan_l]

weird. was it an ooo doc originally?