hyperlink to individual files?

  • Thread starter Thread starter MPSingley
  • Start date Start date
M

MPSingley

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...
 
Also posted in public.excel.misc and public.excel
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


<[email protected]>
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to files? 1
HOW: Click Formula Hyperlink To Trigger Macro 1
!! hyperlinks to listbox column - Possible? 1
Re : Excel Hyperlink to Open an External File 6
Changing Hyperlinks 2
Display File path as hyperlink in outlook 2
Excel Hyperlink in Excel to Devonthink pro File 0
Open Folder containing Jpeg files to get hyperlink 2

Back
Top