Bundle a PDF document in Excel

[Ignition1]

Hi

Not sure if this is possible.

I have a spreadsheet which requires a few criteria to be met before the user can run the macro.

Ideally I'd like to have screen shots of what I want done loaded in a PDF along with text - when the user clicks on the "Instructions" button in my spreadsheet - this PDF will open.

The only way I know how is to simply have the filepath of the PDF in the code when you click the button but as this will be used on multiple PC's which are not always connected to the company network - is there a way to 'bundle' the PDF document with my Excel file so that goes wherever it goes?

 

[Andrew Poulsom]

You can Insert an Adobe Acrobat Document object.

 

[Ignition1]

Thanks.

I've inserted the PDF (it now shows the PDF icon and the file path) - can I hide this from view and simply open the PDF using the button? Looks better that way.

 

[Andrew Poulsom]

You can open the PDF like this:

Private Sub CommandButton1_Click()
    Me.OLEObjects("Object1").Verb
End Sub

Change the object's name to suit.