VBA and command button in Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sclinkenbeard
    New Member
    • Mar 2008
    • 5

    VBA and command button in Excel

    In Excel I have a command button that I want to reference a PDF document and have no idea how to do this. Below is code that I did to do a button with a word doc. Can someone please help me out?
    Thanks

    Private Sub CommandButton12 _Click()
    Dim wdDoc As Object
    Set wdDoc = GetObject("\\Hu sw2fs01\SharedH US\H2-3 MSO Docs\Report Template\Day shift report_v2.doc")
    wdDoc.Parent.Vi sible = True
    Application.Act ivateMicrosoftA pp xlMicrosoftWord
Working...