Hi,

Currently using this formula

=HYPERLINK("C:\Documents and Settings\Archived Jobs\"& F9 &"\"& F8 &".JPG";"Retrieve Order")

F9 being the folder name which changes and F8 being the file name which changes. I actually only need to open the folder now, the folder name changes so this need to be integrated.

Need to open the folder and so I can see the files within that folder

Thanks