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.