This worked ok for me in xl2003 and winXP home:
Option Explicit
Private Sub CommandButton1_Click()
Dim myFileName As String
myFileName = "c:\somefilename.pdf"
Shell Environ("comspec") & " /c " & myFileName, vbHide
End Sub
Another option from John Walkenbach:
http://j-walk.com/ss/excel/tips/tip51.htm
Fabrizio wrote:
I have a userform. In this userform I want the user to be able to access a
users manual (preferably in the form of a .pdf-file). How the user can
access the users manual is of little importance as long as it is convenient
e.g. by pressing a button but preferably the user shall be able to click on
menu (as in word etc.) that is to be placed at the top edge of the user form.
However, I do not know who to make the button work or if possible to write
the code so that a menu is avaliable. Please if someone can help me I would
be most greatful.
Yours sincerly,
Fabrizio S.
--
Dave Peterson