Open a PDF doc from Excel dash board

[IannW]

Hi All

Note to self, write your post in word and then copy to thiswindow, as I have now written the post 3 times, only for the window to crashand reopen without my text L.

Now to my question….
I have created a dash board using Excel and want to be ableto link to PDF docs in another folder. My PDF docs are all name as 4 numbers, ie, 0017.pdf, 0019.pdf and0276.pdf etc…
I want to be able to enter a 4 digit number into a cell andthen click a button next to it that then opens the PDF doc of the same name.
I have tried using a data validation cell using datanarrowed down using Power Query to remove the file extension but don’t know howto then open the selected file, and I didn’t really want to have to scrollthrough a list of around 500 numbers.
Any ideas gratefully appreciated.

IannW

 

[Domenic]

I'm sorry but I don't understand your question regarding the formula. Can you please elaborate?

 

[Greg Truby]

Crikeys! I guess I'm just a whole lot lazier'n ol' Domenic. I wouldn't've fussed with all dat VBA. I woulda just defined a named constant and used a formula...

=HYPERLINK("file:\\" & con.Path & TEXT(A1,"0000") & ".pdf","link")

where con.Path is a name defined to be the path. In my case it was:

="C:\Users\gtruby\Documents\Excel\VBA Lab\"

If'n ya reckon users are gonna have their hearts set on seein' a button, then just format the cell to look like a button.

(Had to use the code tags otherwise the some of the backslashes kept disappearin'.)

 

[Domenic]

Crikeys! I guess I'm just a whole lot lazier'n ol' Domenic. . . .

Well, I wouldn't put money on that.

But yeah, your method is definitely a lot easier. I wouldn't fuss with VBA either.

Cheers!