Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4586
  • Last Modified:

Excel VBA - How to Close a PDF File?

Hi,

I would like to close a pdf file programmatically  using Excel 2010 ( VBA ) regardless of the Adobe Program ( e.g. Adobe Reader, Adobe Acrobat, Adobe Acrobat Pro etc ) that is used to open the said file.

Facts
1. OS: windows 7, 8
2. the pdf file ( e.g. test1.pdf )  can be opened using any of the adobe programs - this depends on which program is installed in the machine
3. once the pdf file is open, it appears to be identified by its file name + adobe program i.e. test1.pdf - Adobe Reader
4. I am able to use the following code to close the file i.e.
     AppActivate "test1.pdf  - Adobe Reader"
     SendKeys "^q"

In this example, I knew the pdf file is open using Adobe Reader.

Questions:
a)How can I determine the full file name ( test1.pdf + whatever Adobe program ) so I can use AppActivate to capture the appropriate string value dynamically - at the point when the file is open programmatically ?
b) Is there a workaround to programmatically close the pdf file if route a is not possible ?

Thank you
0
Russellbrown
Asked:
Russellbrown
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now