Print range of pdf documents via hyperlinks

[excelbry]

I've been looking for a method of doing this task for a while and after experimenting with macros in excel I can officially say I need some help!

I have no experience using VBA so it would be great to get some advice on how I could create a macro for my needs.

I have attached a screenshot to help with this query.

Basically, what I would like to do is the following:

1. Open file 1
2. Print file 1
3. Close file 1
4. Repeat steps 1 to 3 for remaining files

I have the following macro which opens file 1 but this is as far as I have managed to get:

Sub Open_File()
'
' Open_File Macro
' Macro recorded 25/05/2011 by bdy
'
' Keyboard Shortcut: Ctrl+a
'
Range("C3").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

I have tried recording all the steps but have been unsuccesful so far...

The excel document contains the following hyperlink base if this helps:

\\fafile100vm\users$\bdy\Macro Test Folder\PDF Files\

The idea behind this is that I would like to create a button within the spreadsheet where the user can simply click on it and they are able to print out a specified range of files in the correct order. Currently the only way of doing this is by clicking each hyperlink, opening the files, then print them one at a time which is not very efficient.

Thanks,

Bryan

[lyndadodd]

Bryan,
Did you ever resolve this issue? It sounds like the same thing that I need to do.

Thanks
Lynda