Hi all,

I'm looking for a method of printing a batch of pdf files from within excel that are opened via a hyperlink. I use an excel document as an index file for users to navigate their way through the assembly of a vehicle.

Below is a link to a screenshot of the excel file:

http://img7.imageshack.us/i/testprintimage.jpg/

In column G of the document I have "Click Here" hyperlinks, which direct the user to a pdf file for the given task.

The user is able to open each document as they go through the build process which is great if they can use a computer near their station but unfortunately the number of computers available are limited so sometime I have to print the notes out for use. What I would like to do is select all of the hyperlinks from one section and print them in that order. I currently have to do this manually one by one which is time consuming so was looking for a quicker method of doing it?

All the pdf files are stored in 1 location so it's not so easy just to pick out the ones required for printing, plus they would be in alphabetical order instead of the order required for the build process.

Any help or info would be much appreciated. I'm not too clued up on macros so if this is the only option could you explain what would be required?

Many Thanks,
Bryan