Linking to text files in Excel
 

Hey all, just a quick question that seems like it should have a straight
forward answer.

I am designing an Excel table to list and sort resumes our company has
gotten in the recent past. The lady I am working with has forwarded me all of
the emails that have the resumes attached. Right now I am in the process of
downloading them and breaking them up by relevant criteria to organize by.

What I want to know is if there is some way for me to link to these files
directly from the worksheet. I have been putting them into a folder on our
network and it would be much easier for people to be able to click something
instead of having to manually navigate by a directory listing (for example,
C:\Documents and Settings\Soandso)

Thanks for your time,

Linking to text files in Excel
 

How about insert a hyperlink to the file?





"Longtime listener first time caller" wrote:

Hey all, just a quick question that seems like it should have a straight
forward answer.

I am designing an Excel table to list and sort resumes our company has
gotten in the recent past. The lady I am working with has forwarded me all of
the emails that have the resumes attached. Right now I am in the process of
downloading them and breaking them up by relevant criteria to organize by.

What I want to know is if there is some way for me to link to these files
directly from the worksheet. I have been putting them into a folder on our
network and it would be much easier for people to be able to click something
instead of having to manually navigate by a directory listing (for example,
C:\Documents and Settings\Soandso)

Thanks for your time,

Linking to text files in Excel
 

Just right! Thanks a lot, knew it had a simple solution.

"Leung" wrote:

How about insert a hyperlink to the file?





"Longtime listener first time caller" wrote:

Hey all, just a quick question that seems like it should have a straight
forward answer.

I am designing an Excel table to list and sort resumes our company has
gotten in the recent past. The lady I am working with has forwarded me all of
the emails that have the resumes attached. Right now I am in the process of
downloading them and breaking them up by relevant criteria to organize by.

What I want to know is if there is some way for me to link to these files
directly from the worksheet. I have been putting them into a folder on our
network and it would be much easier for people to be able to click something
instead of having to manually navigate by a directory listing (for example,
C:\Documents and Settings\Soandso)

Thanks for your time,