Closing a PDF Doc VBA

[DMT Dave]

Hi everyone, is it possible to close a PDF document this is minimized via a combo after update procedure ?? Adobe acrobat reader is what the PDF is open Via code below, I am wanting to be able to close the active PDF document via another procedure ??



Dim SLOpen, FlowPath, MyItem as String

If Me.cboFolder <> "" Then
SLOpen = Left(Me.cboViewPDF, 9)
If IsNull(MyItem = DLookup("Contact", "tblEdit", "[SONumber] = '" & SLOpen & "'")) Then
FlowPath = "T:\Customer\Customer PDF's\" & Me.cboViewPDF
Application.FollowHyperlink FlowPath
Else
DoCmd.CancelEvent
End If

Kind Regards

Dave

[June7]

AFAIK, can't close a specific file, have to kill an application process. Review https://www.devhut.net/2015/05/28/ms...ill-a-process/

[ssanfu]

Word of warning:

Dim SLOpen, FlowPath, MyItem as String

This declares MyItem as a String and SLOpen & FlowPath as Variants.


To delcare all 3 variables as string, you need to use

Dim SLOpen as String, FlowPath as String, MyItem as String

You MUST Explicitly declare variable types (unlike other programming languages).

[Micron]

Adobe has published a document for interacting with Acrobat and/or Reader using VBA. I suspect that if an object is instantiated for the application and the document, it should be possible. I know that it's possible to populate a pdf form with Access data, so if one can interact like that, it should be possible to close a file and the app - I've just never tried. The data transfer has been covered in this forum before.