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...

what application would be used to open the drawings and what is the file
extension? .dwg?

Mike

" wrote:

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...

they are .tif scanned drawings.. microsoft office document imaging is
used to view them

Never mind I won't be able to test it anyway because I won't have the
application. With a list of your drawing names in A1 _ a100 (extend as
necessary paste this into the worksheet code by right clicking the tab abd
paste.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("A1:A100")) _
Is Nothing Then Exit Sub
'Change the extension to the correct one
Filetoopen = Target.Value & ".txt"
'Change the path to your application
'and the application nam as required
Shell "c:\windows\system32\notepad.exe c:\" & Filetoopen, vbMaximizedFocus
End Sub

Mike


" wrote:

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 have another response at your other post.

wrote:

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...

--

Dave Peterson