Determining if COM add-in is installed to create pdf files from Wo

[Doug]

I have an access application that creates word documents and will save them
as pdf if the user has the com add-in installed. Is there a way to determine
that in VBA other than just trying to save the file and see if it errors out?

 

[Graham Mayor]

If you mean the Acrobat COM add-in (Word 2007's PDF creation tool is not
installed as a COM add-in) then from a current thread in the vba.general
forum

Set pmkr = Nothing ' locate PDFMaker object
For Each a In Word.Application.COMAddIns
If InStr(UCase(a.Description), "PDFMAKER") > 0 Then
Set pmkr = a.Object
MsgBox a.Description & " is installed"
Exit For
End If
Next
If pmkr Is Nothing Then
MsgBox "Cannot Find PDFMaker add-in", vbOKOnly, ""
Exit Sub
End If

If you mean the 2007 tool and you find a solution post back.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>