Hi John
This code will open a pdf file. See if you can adapt it to suit your needs
On Excel 2010 it does prompt a couple of security nags that I'm not sure if you can eliminate. I haven't looked very hard
Cheers

Sub OpenHlink()

Dim PDF2Open As String, FolderPath As String, File2OpenPath As String

    PDF2Open = "Coconut Bread Recipe.pdf" ' Name of pdf file to open
    FolderPath = "C:\Users\" & Environ("username") & "\Desktop\" ' Path to Desktop
    File2OpenPath = FolderPath & PDF2Open ' Folder path & name of the file to open
            
    ThisWorkbook.FollowHyperlink File2OpenPath  ' Open the file
                        
Exit Sub

End Sub