Need to create an automatic hyperlink
 

I'm using Excel 2003, Windows XP.

Okay I have a workbook with a main spreadsheet and about 150 other
spreadsheets with images in them.

I have the names of the other spreadsheets in cell b2.

How do I create a hyperlink that will concantenate the name in cell b2 to a
hyperlink and point it to the spreadsheet with that name? I know I can do it
by manually selecting each cell and hyperlinking manually, but with over 150
it's taking a while.

Thanks.

Need to create an automatic hyperlink
 

I tried
=HYPERLINK("file:////"&b2,"Click me!")

and it fails (can't find specified file).

" wrote:

I'm using Excel 2003, Windows XP.

Okay I have a workbook with a main spreadsheet and about 150 other
spreadsheets with images in them.

I have the names of the other spreadsheets in cell b2.

How do I create a hyperlink that will concantenate the name in cell b2 to a
hyperlink and point it to the spreadsheet with that name? I know I can do it
by manually selecting each cell and hyperlinking manually, but with over 150
it's taking a while.

Thanks.

Need to create an automatic hyperlink
 

Does B2 include the drive and path (or UNC path)?

Maybe something like:

=HYPERLINK("file:////c:\my folder\"&b2,"Click me!")
or
=HYPERLINK("file:////server\sharename\"&b2,"Click me!")

If this doesn't help, what's the name of the file?

======
I like to put the folder name (including the final backslash) in a cell (like
A1) and use:

=HYPERLINK("file:////"&$a$1&b2,"Click me!")

Then if the folder ever changes, I only have to change that one cell.

wrote:

I tried
=HYPERLINK("file:////"&b2,"Click me!")

and it fails (can't find specified file).

" wrote:

I'm using Excel 2003, Windows XP.

Okay I have a workbook with a main spreadsheet and about 150 other
spreadsheets with images in them.

I have the names of the other spreadsheets in cell b2.

How do I create a hyperlink that will concantenate the name in cell b2 to a
hyperlink and point it to the spreadsheet with that name? I know I can do it
by manually selecting each cell and hyperlinking manually, but with over 150
it's taking a while.

Thanks.

--

Dave Peterson

Need to create an automatic hyperlink
 

Do I need to include the drive and path?

I'm going to be emailing this to someone. They will not be saving it to the
same drive and path that I have it on. Since I'm trying to link to a sheet
within the same workbook, I would think that I don't need to include the
drive and path.

"Dave Peterson" wrote:

Does B2 include the drive and path (or UNC path)?

Maybe something like:

=HYPERLINK("file:////c:\my folder\"&b2,"Click me!")
or
=HYPERLINK("file:////server\sharename\"&b2,"Click me!")

If this doesn't help, what's the name of the file?

======
I like to put the folder name (including the final backslash) in a cell (like
A1) and use:

=HYPERLINK("file:////"&$a$1&b2,"Click me!")

Then if the folder ever changes, I only have to change that one cell.

wrote:

I tried
=HYPERLINK("file:////"&b2,"Click me!")

and it fails (can't find specified file).

" wrote:

I'm using Excel 2003, Windows XP.

Okay I have a workbook with a main spreadsheet and about 150 other
spreadsheets with images in them.

I have the names of the other spreadsheets in cell b2.

How do I create a hyperlink that will concantenate the name in cell b2 to a
hyperlink and point it to the spreadsheet with that name? I know I can do it
by manually selecting each cell and hyperlinking manually, but with over 150
it's taking a while.

Thanks.

--

Dave Peterson
.