Re: [MS_AccessPros] Closing PDF file from VBA-Open PDF in Minimize View

 

Norbert-

You have no control with FollowHyperlink.  The file opens in whatever is defined as the default app for that file type using the default settings for the app.  I'm not certain, but I don't think Adobe Reader has ever supported automation from Office apps.  To close the app, you would have to find its Window Handle and then send a close command using a Windows API.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On May 18, 2015, at 8:22 PM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Version: MSAccess 2010/2013

I am opening a PDF file with the following code:

strScanFolderName ="C:\PDFFolder\Client\269378420150518050012"

Application.FollowHyperlink (strScanFolderName & strFile & ".pdf"), , True

User will verify that the file was scanned correctly and the after a few seconds I would like the open PDF to close.

1-What is the VBA code to close the open PDF file?

2-The PDF is opening in Maximize View.

    How can I open the PDF file in Minimize View?

Thanks

Norbert

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___