Access 2016 Close a PDF document using VBA

Question

Hi  I need to check if a pdf file is open if it is I need to close it.

I have no problem checking if the file exists in the folder what I do need help with if the file is open how do I close it using VBA.

Dim app As Object, avdoc As Object

Set app =CreateObject ("AcroExch.App")

Set avdo = app.GetActiveDoc.strPath ' I have not put all the code in for the strPath 

     avdoc.Close

Set app = Nothing

Set avdoc= Nothing

The above does nothing no errors 

So basically if the AXC.pdf file is open in its folder I want to close it without making any changes.

Answer 1

Never used it but this looks promising...

http://www.theaccessweb.com/api/api0025.htm