Open pdf, print and close from vba

[jak26]

Hi

Hopefully someone can help. I am wanting to open a pdf, print and close all from vba.
the address is embedded in the worksheet. I can get the pdf to open but no further than that


My code thus far is:
Private Sub CommandButton1_Click()

addy = Sheets("laska").Range("af3").Value

x = Shell("EXPLORER.EXE " & addy, vbNormalFocus)

End Sub

I have been playing around with the application.sendkeys but with no luck

Cheers
Jeff

 

[Glory]

Can you set a reference to a pdf object library in excel's VBA "Tools->References" menu?

If you can then you can dimension x as a pdfdocument or something, then push "." and intellisense will show you all the possible methods you can do with a pdf document.

There must be a print method. Have you tried ".PrintOut"?