Ask a Question Sign up for Free 125 Experts currently online. Ask Questions for Free!

Save as PDF in VBA - Mac Excel

In Excel after selecting Print, there is an option for Save as PDF. However, someone has noticed that there doesn't seem to be any way to access that option in VBA. Does anyone know if it is supported in VBA? And if so, how to access it? Thanks...

Results 1 to 4 of 4

  1. #1

    Save as PDF in VBA

    In Excel after selecting Print, there is an option for Save as PDF. However,
    someone has noticed that there doesn't seem to be any way to access that
    option in VBA.

    Does anyone know if it is supported in VBA? And if so, how to access it?

    Thanks
    shades
  2. #2

    Re: Save as PDF in VBA

    I've been trying to figure this out for the last few days and from
    what I can see in Excel VBA Help it is not supported for VBA on on the
    Mac. I would be interested in knowing if alternatively there is a way
    to save as pdf in Applescript - or can Realbasic save as pdf?

    Richard



    "shades" <microsoft.com> wrote in message news:<2628301c462b9$810ef750$gbl>... 
    Richard
  3. #3

    Re: Save as PDF in VBA

    On 7/5/04 6:07 PM, in article
    google.com, "Richard Garber"
    <com> wrote:
     

    "Save as PDF" is really part of Mac OS X's Print dialog - nothing to do with
    Word's object model, even on the Mac. I've tried to do it by "GUI Scripting"
    but, as is not uncommon, that doesn't work.

    I, for one, have requested "Save to PDF" as an AppleScript feature (it's
    probably more likely to get added to AS at the moment than to VBA). You
    should also make a feature request via the Help menu/Send Feedback. The more
    people request it, the more likely it will come to pass. Or perhaps it's
    something that Apple will make scriptable for all apps.

    At the moment, you might indeed want to check out RealBasic and see if it
    can do it.

    --
    Paul Berkowitz
    MVP MacOffice
    Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
    AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

    Please "Reply To Newsgroup" to reply to this message. Emails will be
    ignored.

    PLEASE always state which version of Microsoft Office you are using -
    **2004**, X or 2001. It's often impossible to answer your questions
    otherwise.

    Paul
  4. #4

    Re: Save as PDF in VBA

    I have made sure that this information has been added to our feature
    suggestion list. Thank you very much for sending the information.

    Natasha Bishop
    Microsoft Employee


    Paul Berkowitz <com> wrote in message news:<BD1F2588.6C600%com>... 
    Natasha_Microsoft

Similar Threads

  1. Save as
    By colsup2 in forum Microsoft Word
    Replies: 15
    Last Post: 10-03, 04:34 PM
  2. Save as ... gif
    By George in forum Microsoft Visio
    Replies: 3
    Last Post: 07-19, 06:13 AM
  3. Do You Want to Save Your Changes?
    By Dean in forum Microsoft Word
    Replies: 3
    Last Post: 07-02, 07:25 AM
  4. Do you want to save the changes to email?
    By Robert in forum Microsoft Outlook
    Replies: 3
    Last Post: 07-01, 07:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100