VBA code to open folders and pdf file inside the folders

Hi,

I have a list of ids in excel sheet like 1234, 4567, 7890.
I have various folder created whose names ends with these ids ( ***_1234, ***_4567).
Inside these folders i have pdf file ending with dates (*** 23 Apr 2013, *** 20 Jun 2013).

I wanted a code which will match the ids in excel file and open the respective folders ending with those ids. After opening the folders it should open the latest PDF file using date.

Thanks..

Anyother way i can do this. The folder names are actually company name with their ids. PDF file name is also company name with Dates. I am ready to make necessary changes in the folder names if it is making it easier.

edit post removed

Thanks, my main prob is opening only those folders whose names are listed in the excel.