We help IT Professionals succeed at work.

Easy excel macro / fomula needed

abdb469
abdb469 used Ask the Experts™
on
I need to create a macro in the attached spreadsheet which when run, will open a range of spreadsheets in a folder called “Z:\Dump\Test_Funds” and pull the corresponding value in the cell to the right of 2 cells containing the words “Fund’s name” and “Fund's NAV (MN EUR)” .

For the purpose of this macro, the spreadsheets begins with opening files starting with the name “2012-0001” and finish upto “2012-1000” but their full file name will include some words after the initial number e.g. “2012-0001 Emerging markets Fund”.  The macro should only focus on the files that begin with those numbers with the range specified.  Also at present there are only some 50 files in the folder, so some sort of command to loop until it finds all files in that range but end if no more.

Thanks.
summary-macro-tes--simple-t.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I would  base my code on this webposting.

http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder 

It's only a first step, but it should get ya started.

Author

Commented:
No thats not what I am looking for.  Besides, I dont have a clue how to write that but was looking for someone to write the code......
Commented:
The answer to your question is in the attached file.
summary-macro-test.xls

Author

Commented:
Excellent, thx.