Using a command button to open a PDF

I'm currently using this code to try and open a PDF but its not seeming to work.

I currently have it in the sheet's code, but nothing is happening.

Any suggestions? Should it be somewhere else?

Please Login or Register  to view this content.

Oh:

I forgot, i'm getting this error when I run it

"Run-Time Error '-2147221014(800401ea)' : Cannot open the specified file."

Are you sure the file at that location exists?

I had no problem running the code replacing your path with my own.

Try navigating to the file with windows explorer and copy and pasting the path from that window.

This is also to a shared location ran from Sheet1:

Please Login or Register  to view this content.

But its a location I have read/write access to. Do you have permissions set up to do so?

It sounds to me like the filename/path you have typed isn't exactly as it is saved.

hmm, i'm copying and pasting it directly from the properties window.

Could it have something to do with adobe or how the file has been saved?

I have all the permissions.

ThisWorkbook.FollowHyperLink

What exactly does this mean? am I supposed to have some type of hyper link in my sheet?

Sorry I don't think I looked at it closely enough the first time. If you are trying to run this from a button try this:

Please Login or Register  to view this content.

Placing your path between the quotes. Try placing it in a blank module.

Yay it worked! it was the "Thisworkbook.path &"

And I kept it in the sheet code, and it works fine!

Thanks so much!