open hyperlink using range selection method

[shido]

Hi All,

Wondering if you can advise how to open hyperlink using range selection by input box and print open documents.

for example: If I select A4:A5, i should be able to open and print files link to row 4 i.e cell A4 and cell C4 and print them and move to next selection.

In addition, is there way to add message either to print selection one at a time or print all.

If get error in opening file, a message box "row # ??, failed to open, please check link".

My codes are as follows,..

Please Login or Register  to view this content.

Sample spreadsheet is attached for your reference.

Thank you in advance and Kind Regards,

test.xls

[shido]

post redited... please advise