Is there a way to hyperlink multiple cells to multiple files without having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink so
that when you click on it the native file opens.

Thank you.

No, only one hyperlink per cell.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote in
message ...
Is there a way to hyperlink multiple cells to multiple files without
having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink so
that when you click on it the native file opens.

Thank you.

I only need one hyperlink per cell, but I have a whole column of cells I want
to hyperlink to a folder that contains the files. I know I can link the
whole column to one file. I'm just looking for a marco or something that
will let me link cell 1 to file 1, cell 2 to file 2 and so on without having
to do one at a time. Any idea how to do that?

"Zack Barresse" wrote:

No, only one hyperlink per cell.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote in
message ...
Is there a way to hyperlink multiple cells to multiple files without
having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink so
that when you click on it the native file opens.

Thank you.

Yes, but you have to be a little more specific in your particulars. Let me
ask a few questions here ...

Are you wanting to perform this only once? Or on-going?
Will you be hyperlinking every file in a specific folder?
Are there any other files in this folder?
Is it the same file location that you are putting the hyperlinks into?
Where is that one located?
Are there any specifics/requirements on the friendly names of your
hyperlinks?
Any other requirements or details?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote in
message ...
I only need one hyperlink per cell, but I have a whole column of cells I
want
to hyperlink to a folder that contains the files. I know I can link the
whole column to one file. I'm just looking for a marco or something that
will let me link cell 1 to file 1, cell 2 to file 2 and so on without
having
to do one at a time. Any idea how to do that?

"Zack Barresse" wrote:

No, only one hyperlink per cell.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote
in
message ...
Is there a way to hyperlink multiple cells to multiple files without
having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink
so
that when you click on it the native file opens.

Thank you.

Thanks for the help, answers below

"Zack Barresse" wrote:

Yes, but you have to be a little more specific in your particulars. Let me
ask a few questions here ...

Are you wanting to perform this only once? Or on-going? I have a program, Z-Print, that creates a log(csv) after you batch print a folder. There is a column that lists the filenames. That's the one I want to link back to the files that were printed. So once the log is generated I would only need to hyperlink the cells one time.

Will you be hyperlinking every file in a specific folder? Yes

Are there any other files in this folder? Yes, but I can remove the other files if it's a problem.

Is it the same file location that you are putting the hyperlinks into? Yes, same main folder, sometimes with subfolders.

Where is that one located? The folder can be on the network or the C: drive, whichever is easiest.

Are there any specifics/requirements on the friendly names of your
hyperlinks? Not sure what a friendly name is.

Any other requirements or details? I have a column with the file names listed all the down. I want to have a hyperlink in each cell under that column so that when I click on the filename, that file opens. It's easy to do one at a time, but I'd like to be able to automate the linking. Ideally, I'd have a CD with one folder containing all the files and one excel sheet containing all the file info. When I click on the link in Excel, the original file would open for viewing.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote in
message ...
I only need one hyperlink per cell, but I have a whole column of cells I
want
to hyperlink to a folder that contains the files. I know I can link the
whole column to one file. I'm just looking for a marco or something that
will let me link cell 1 to file 1, cell 2 to file 2 and so on without
having
to do one at a time. Any idea how to do that?

"Zack Barresse" wrote:

No, only one hyperlink per cell.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote
in
message ...
Is there a way to hyperlink multiple cells to multiple files without
having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink
so
that when you click on it the native file opens.

Thank you.

Let me specify a couple of things here. I will call the document you want
to insert the hyperlinks into as the Original Workbook. If all files are to
be contained in the same folder, you will need a way to differentiate them.
If nothing else we can just use the name of the Original Workbook.

If the filenames are already in cells in a column, then all we'll need is a
location. This of course would be a breeze if the files were in the same
location as the Orignial Workbook. If this is the case, post the range
these names are located in. If this isn't the case, it will most likely
prove to be a little more difficult and in-depth.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"beginnerExceluser" wrote in
message ...
Thanks for the help, answers below

"Zack Barresse" wrote:

Yes, but you have to be a little more specific in your particulars. Let
me
ask a few questions here ...

Are you wanting to perform this only once? Or on-going? I have a
program, Z-Print, that creates a log(csv) after you batch print a folder.
There is a column that lists the filenames. That's the one I want to
link back to the files that were printed. So once the log is generated I
would only need to hyperlink the cells one time.

Will you be hyperlinking every file in a specific folder? Yes

Are there any other files in this folder? Yes, but I can remove the other
files if it's a problem.

Is it the same file location that you are putting the hyperlinks into?
Yes, same main folder, sometimes with subfolders.

Where is that one located? The folder can be on the network or the C:
drive, whichever is easiest.

Are there any specifics/requirements on the friendly names of your
hyperlinks? Not sure what a friendly name is.

Any other requirements or details? I have a column with the file names
listed all the down. I want to have a hyperlink in each cell under that
column so that when I click on the filename, that file opens. It's easy
to do one at a time, but I'd like to be able to automate the linking.
Ideally, I'd have a CD with one folder containing all the files and one
excel sheet containing all the file info. When I click on the link in
Excel, the original file would open for viewing.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser" wrote
in
message ...
I only need one hyperlink per cell, but I have a whole column of cells I
want
to hyperlink to a folder that contains the files. I know I can link
the
whole column to one file. I'm just looking for a marco or something
that
will let me link cell 1 to file 1, cell 2 to file 2 and so on without
having
to do one at a time. Any idea how to do that?

"Zack Barresse" wrote:

No, only one hyperlink per cell.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"beginnerExceluser"
wrote
in
message ...
Is there a way to hyperlink multiple cells to multiple files without
having
to link one at a time?

The cells contain the filename, I'd like to make each one a
hyperlink
so
that when you click on it the native file opens.

Thank you.

I'd use a helper column of =hyperlink() formulas:

Depending on what was in the original column:

=hyperlink(a1)
or
=hyperlink("file:////" & a1)
or
=hyperlink("File:////" & "C:\my documents\pdffiles\ " & a1)
or
=hyperlink("File:////" & "C:\my documents\pdffiles\ " & a1 & ".pdf")

And drag down.

beginnerExceluser wrote:

Is there a way to hyperlink multiple cells to multiple files without having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink so
that when you click on it the native file opens.

Thank you.

--

Dave Peterson

Dave, thanks for the help, the simple answer worked the best for me. Macros
are a little out of my league so far.

"Dave Peterson" wrote:

I'd use a helper column of =hyperlink() formulas:

Depending on what was in the original column:

=hyperlink(a1)
or
=hyperlink("file:////" & a1)
or
=hyperlink("File:////" & "C:\my documents\pdffiles\ " & a1)
or
=hyperlink("File:////" & "C:\my documents\pdffiles\ " & a1 & ".pdf")

And drag down.

beginnerExceluser wrote:

Is there a way to hyperlink multiple cells to multiple files without having
to link one at a time?

The cells contain the filename, I'd like to make each one a hyperlink so
that when you click on it the native file opens.

Thank you.

--

Dave Peterson