Bart you are very close:

=HYPERLINK("E:\" & Sheet1!B7,"link to folder")

adapt to your logical drive & folder name.
--
Gary''s Student - gsnu200751


"Bart" wrote:

Hi there,

I'm attempting to create a hyperlink in Sheet2 that will open a folder whose
name is stored in a cell in Sheet1. Here's what I've got so far:

=HYPERLINK("I:\2007GSR\"&B7,"Link to Folder")

B7 contains the folder name but this assumes the cell is on the same sheet
as the hyperlink. How do I get the formula to realize it's not?

Thanks.

Bart