?
Solved

Adobe versions

Posted on 2011-10-31
10
Medium Priority
?
270 Views
Last Modified: 2012-05-12
Hi,
I have developed an Access Application that uses Adobe to display .pdf documents using the following VBA Code:

strExePath = "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe"
Shell "" & strExePath & " " & strDocPath & strDocumentName & "", vbMaximizedFocus

This of course works with Adobe 9.0

Question:
How do I modify the code so it will automatically apply to any version of Adobe?

Thanks,

Biggles1
0
Comment
Question by:Biggles1
  • 5
  • 4
9 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 37056387
have you tried using

followhyperlink  strDocPath & strDocumentName
0
 

Author Comment

by:Biggles1
ID: 37061529
I am not familiar with 'followhyperlink'
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37062100
did you try it ?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:Biggles1
ID: 37062579
Thanks Capricorn1 for your quick response.  It worked perfectly!

Biggles1
0
 

Author Comment

by:Biggles1
ID: 37089709
Live and learn!
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37062656
Biggles1,

you made a request to accept your own post as the correct answer !
0
 

Author Comment

by:Biggles1
ID: 37068695
NO! I acceped Capricorn1's solution.  I did NOT object.  This is an error on my part.

I REPEAT:

I AM ACCEPTING CAPRICORN1'S SOLUTION WHICH WORKS PERFECTLY WELL

Sorry for any misunderstanding.

Biggles1
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37069140
Biggles1,
click on the Request Attention above and ask for help to change your request..
0
 

Author Closing Comment

by:Biggles1
ID: 37093283
Thanks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question