Using Excel VBA, how can I determine the pdf files that are opened in the user's session?

[Mycological]

If I were writing this to find opened word documents the code would be

Set wdApp = GetObject(, "Word.Application")

This gives me the number of open word documents.

How can I do the same for pdf files?

[try67]

Via the JavaScript object, run this code:

app.activeDocs.length

PS. In the future you'll be better off to ask questions about Acrobat in one of the Acrobat forums, like this one: Acrobat SDK

[Mycological · Accepted solution]

I will go to Acrobat SDK in the future.

The answer is was looking for is below, it works well. Thanks

        Dim pdApp As Acrobat.AcroApp

        Dim pdDoc As Acrobat.AcroPDDoc

        Dim numPDF As Integer

Set pdApp = CreateObject("AcroExch.App")

Set pdDoc = CreateObject("AcroExch.PDDoc")

numPDF = pdApp.GetNumAVDocs

MsgBox (numPDF)