Attach a .PDF file to Excel

My Excel (Office 2007) has a column that is devoted to job numbers.

I create my job sheets as .PDF files & save them with job numbers.

Is there a way where I can click on the job number in Excel & have this open up the relevent .PDF file?

Any help or pointers appreciated & please bear in mind my knowledge of Excel is limited. Thanks

Thanks for that, yes it did what I wanted.

But is there a way to make it less long winded?

There is a lot of navigating to get to the correct folder, the path is
\\Nasbox\Leaflets\Work Sheets\602.pdf

And the Insert Hyperlink dialogue box doesn't allow for date modified (which would make it quicker to get to relevant file) or a last folder used.

I have all the .PDF files I want linked to in one folder & they are all numbered 601, 602, 603 etc. So is there a way that if I type in 603 in a particular column in Excel it will automatically link to the 603.PDF file?

Bet there isn't!!! ???

Thanks for that but can you elaborate as at the mo I'm not really sure what to do with this?

=HYPERLINK("C:\Documents and Settings\Martin Wilson\My Documents\"&B1&".pdf")

I have changed it to my files location
=HYPERLINK("\\Nasbox\Leaflets\Work Sheets\"&600&".pdf")

I right clicked on the cell, selected hyperlink, pasted the above, changed the B1 to 600 but keep getting a cannot open the specified file.

If it was working correctly wouldn't I have to still paste all of that into each cell I wanted the link to work on & then manually adjust each B1 to the number I want?

Confused???

Hi Dave

That looked fantastic, unfortunately it didn't work?

I downloaded the GetPDFs.xls & saved it to my trusted folder where my main excel spreadsheet reside, full of macros & all enabled.

On my C; drive I created a folder called "Work Sheets" & put 4 .pdf files in it.

In Cell A2 I tried entering both "Work Sheets" & "C:\Work Sheets"

Upon hitting Enter nothing happened?

Under the Developer Tab - Macro Security - Enable All Macros (was checked)

Macros - Macro Name - ListPics - Run (nothing happened?)

Any idea why it isn't running?

I clicked in Cell A2, nothing.

I ran the Macro, nothing.

Just to check I'm running the macro correctly.
Developer Tab - Macros - Macro name - ListPics - Run

Ta Martin, I didn't get back to you earlier as I didn't follow what you meant.

Still not that clear on what you mean, could you explain it to an idiot please?

The path to where I store the .pdfs is "\\NASBOX\Leaflets\Work Sheets"

???

No
"\\NASBOX\Leaflets\Work Sheets"
Is the exact path, its a seperate Server connected via ethernet.

Don't like mapping network drives, they frequantly don 't reconnect.

Thanks Dave, followed the link & copied the code

--------------------------------------------------------------------------------------' Module : Module1
' DateTime : 09/05/2007 08:43
' Author : Roy Cox (royUK)' Website : www.excel-it.com for more examples and Excel Consulting
' Purpose : Open all worksheets in a specific folder' Disclaimer; This code is offered as is with no guarantees. You may use it in your' projects but please leave this header intact.
'---------------------------------------------------------------------------------------
Option Explicit
Sub Open_All_Files()
Dim oWbk As Workbook
Dim sFil As String
Dim sPath As String

sPath = "C:\Work Sheets\"
'location of files
ChDir sPath
sFil = Dir("*.xlsx") 'change or add formats
Do While sFil <> "" 'will start LOOP until all files in folder sPath have been looped through Set oWbk = Workbooks.Open(sPath & "\" & sFil) 'opens the file

' do something
oWbk.Close True 'close the workbook, saving changes
sFil = Dir
Loop ' End of LOOP
End Sub

But every time I clicked within Excel it just opened up the Visual Basic Window & then came up with a compile error.
Too be honest not really sure what this bit of code is meant to do, how I run it or how it creates & displays my hyper-linked .pdfs?

Martin, please can you elaborate on your hyperlink method as its not working for me?

I have selected the Cell A85, right clicked & selected Hyperlink.
In the address bar I have pasted
=HYPERLINK("c:\Work Sheets\"&a1&".PDF")
& click OK

The text that then appears as a hyperlink is C:\Work Sheets\Add Highlight.PDF

Now when I click this in the spreadsheet I get a cannot open the specified file?

If I type over the hyperlink, the number of one of the work sheets, say 557 I get the same error message.

More help please???

I have attached a sample of the worksheet which may help with advice?

Column A is the one where the jobs are numbered & where the hyperlink should refer to the individual .PDF file stored at
\\Nasbox\Leaflets\Work Sheets
which is a server.

Thanks