Thanks for the response, I never made it really clear as such. What I am
looking to do is for reports such as injury etc. I want to implement a
userform which asks for the basic information date of report what it is for
etc. Then I want to have that information stored on to a worksheet. I am
fine will all of the code for this but what I am trying to work out is that
I want to scan the particular report to the harddrive and have a hyperlink
to it. I wanted to have it go onto the workbook but I guess that would make
the program pretty bulky to run.

I hope this helps

Greg