VBA code to open folders and pdf file inside the folders

[rockybalboa]

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.

Please let me know whether this is possible or not. If not also suggest some other way to do this.

Thanks..

[patel]

do you want only open the pdf files ? and then ?

[rockybalboa]

No actually i have to create a booklet of all the pdfs

[Excel Fox]

What do you mean by booklet of all PDFs? Do you want to merge all PDFs? Or do you want to create a master list of hyperlinks to all the PDFs|

[rockybalboa]

I wanted to bring all the pdfs together and make it a single file.

[patel]

with Excel ? why not with a dedicated software ?

[rockybalboa]

Yes there is a separate software i will use for that which will create a book of PDFs
The folder names are actually company names with their ids. PDF file names are also company names with Dates.
I am ready to make necessary changes in the folder names if it is making it easier.

[patel]

folder names are not a problem, problem (for me) is joining pdf files with excel

[rockybalboa]

So can we do something like it identifies all the folders and then the latest PDF files inside those folders and copy all the PDFs to a new folder.

[snb]

crossposted: VBA code to open folders and pdf file inside the folders