Great, glad it helps!

Are you using?:

=HYPERLINK("C:\"&A2,"Click Here")