how to Automatically save a file as PDF (A Docx, for example)
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: how to Automatically save a file as PDF (A Docx, for example)

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how to Automatically save a file as PDF (A Docx, for example)

     
    Hi all,

    This is my first message on this community, I'm glad for having register.

    I'm trying to add a functionality to a program I've developed using Excel and VBA. I want to be able to open a PDF file and print as PDF in another file, all this automatically.

    Now you wonder "Why opening a PDF and save it as PDF?". It is becouse I have PDF files that doesn't work properly on old readers and I solve it by opening them and printing as PDF using CutePDF.

    I've read many threads explaining how to save as PDF an spreadsheet but I've no clear how to do this that I need.

    Any Help?

    Regards

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    Any advice?

    Regards in advance

  3. #3
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    My last try to this thread

    Thanks

  4. #4
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    What versions of Windows & Office are you using?
    Cheers
    Paul Edstein
    [MS MVP - Word]

  5. #5
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    Many thanks for your interest, Macropod,

    I'm using Office 2016 and Windows 10

    Regards

  6. #6
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    So why not open the PDFs using Word, then use Save As to create the new copies of them?
    Cheers
    Paul Edstein
    [MS MVP - Word]

  7. #7
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    If I try to open those PDFs using Word a get a message saying something like "This PDF contains interactive features that are not compatible with the PDF distribution. Word will not show this content".

    I'm afraid the only solution is opening with adobe reader and print as PDF with cutePDF or another PDF converter.

    Many thanks

  8. #8
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    2,656
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    You might be able to suppress that warning via:
    Application.DisplayAlerts = wdAlertsNone
    resetting it afterwards to:
    Application.DisplayAlerts = wdAlertsAll
    The only issue you then need to resolve is whether any content compatible with the earlier readers you're trying to work with is lost.
    Cheers
    Paul Edstein
    [MS MVP - Word]

  9. #9
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

    By opening those files directly with Word (right click, open with Word), if I ignore this message I lose lot of content of the file, so I suppose that calling Word from an Excel macro would give me the same result.

    Of couse, as I told, opening those files with Adobe and printing in PDF with CutePDF creates a versión that Works on old Adobe reader versions. Perhaps it could be posible using another PDF writer from CutePDF.

    There is a lot of info over the internet explaining how to print as PDF an Excel sheet, the problema is I have to do it with a PDF, hehe.

    Regards and thanks again.

  10. #10
    New Member
    Join Date
    Nov 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to Automatically save a file as PDF (A Docx, for example)

      
    I've also found information about take a PDF and automatically print (on a physical printer), I suppose it could work with a PDF printer, but then it surely ask me for every filename to use, and I want to set those filenames via code and do all without user interaction.

    Regards

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com