PC Review


Reply
Thread Tools Rate Thread

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

 
 
Doug
Guest
Posts: n/a
 
      27th Oct 2009
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?
 
Reply With Quote
 
 
 
 
Graham Mayor
Guest
Posts: n/a
 
      28th Oct 2009
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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Doug wrote:
> 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?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining if Outlook is installed? Tony Toews [MVP] Microsoft Outlook VBA Programming 6 6th Jan 2010 09:36 PM
Determining if Outlook is installed? Tony Toews [MVP] Microsoft Outlook Discussion 6 6th Jan 2010 09:36 PM
determining whether VC8 C/C++ SxS assemblies are installed. RossettoeCioccolato Microsoft VC .NET 4 4th Dec 2006 09:38 AM
how do you create a setup file from program files that are already installed? jwmpro@gmail.com Microsoft Dot NET Compact Framework 0 16th Jul 2006 07:27 AM
Determining whether sqlclient is installed, and installing it Rod Early Microsoft Dot NET Compact Framework 2 30th Apr 2004 01:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:54 AM.