+ Reply to Thread
Results 1 to 2 of 2

Close Adobe Acrobat from Excel - attn: NickHK

  1. #1
    quartz
    Guest

    Close Adobe Acrobat from Excel - attn: NickHK

    Does anyone know how to get a reference to Adobe and/or close the app?
    I am using Windows XP with Office 2003 and Adobe Professional 6.

    FYI, the following function starts Adobe, prints a file, and closes the
    file. Now I want to close the app:

    Public Function PDFPrintFile(argAdobeAppFullName As String,
    argPDFFileToPrintFullName As String)
    'START ADOBE APPLICATION AND PRINT A FILE
    Shell argAdobeAppFullName & " /p /h " & argPDFFileToPrintFullName
    End Function

    Even if I use a return value with Shell, and try something like:

    retVal.Quit

    I get an error. Can anyone help? Thanks in advance.

  2. #2
    Registered User Ivan F Moala's Avatar
    Join Date
    10-25-2003
    Location
    Auckland, New Zealand
    Posts
    71
    If you just want to print the Doc then try the ShellExercute API

    Please Login or Register  to view this content.
    Kind Regards,
    Ivan F Moala From the City of Sails
    \1

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1