Checking if Adobe is installed via VBA

John Sheehy
John Sheehy used Ask the Experts™
on
I have an Access application that can export fields to a PDF file.  However, for this work it needs the full version of Adobe installed.  Not just the reader.  So I was wondering if there was a way to check programmatically to see if Adobe Acrobat was loaded and not just the reader.

Thanks John
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Probably a check of the registry for specific keys is your best bet.

Do you have code to read registry keys?

Jim.
John SheehySystem Security Manager

Author

Commented:
I do not.  I wasn't thinking this was going to be that in depth.  LOL
Roy CoxGroup Finance Manager

Commented:
The last reply here looks like it should work
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
If your going to go out to the windows scripting shell, you might as well use WMI.   But really a Windows API call is all you need to read the registry, which will be faster and more efficient.  Here's a page with code for that:

http://access.mvps.org/access/api/api0015.htm

 As for the Key, there are several you could check for:

\HKEY_CURRENT_USER\Software\Adobe\Adobe Acrobat

or

\HKEY_CLASSES_ROOT\.pdf\ShellEx

 and get the .exe that's registered for .PDF's.

  but it sounds like the first is closer to what you want.

Jim.
Top Expert 2014

Commented:
Access (2007 and later) is capable of creating PDF files natively
John SheehySystem Security Manager

Author

Commented:
Access 2007 and later can create a PDF file, and our app does that a lot.  But when you want to use a fillible form  with fields filled from access it seems you need Adobe full installed and not just the reader.  So that kind of stinks.  It would be great if Access allowed digital signatures like the ones that are used on Adobe PDF signature block.

John
John SheehySystem Security Manager

Author

Commented:
Thee is no known solution as of yet.  I am sure I will find a third party API that will do the trick but for now we will just output the forms to a regular PDF reader type and they can sign manually till we find a solution.

Thanks to all who responded.

John

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today