hyperlink to individual files?
 

If i have a list of drawing numbers.. such as 2200034567, 2200034568
in a column in excel, with a description of each file in the next
column over, and all of those files are located in one folder.. is
there a way i can use one general equation to have excel search for
that file in the folder and open it if you clicked on the 22 number?

Thanks for any help in advance!!

i know there are ways to do it.. i just dont have the time to
hyperlink 15,000 drawings...

hyperlink to individual files?
 

Also posted in public.excel.misc and public.excel
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



wrote in message If i have a list of drawing numbers.. such as 2200034567, 2200034568
in a column in excel, with a description of each file in the next
column over, and all of those files are located in one folder.. is
there a way i can use one general equation to have excel search for
that file in the folder and open it if you clicked on the 22 number?

Thanks for any help in advance!!

i know there are ways to do it.. i just dont have the time to
hyperlink 15,000 drawings...