+ Reply to Thread
Results 1 to 4 of 4

Save word document with comments as pdf -- dialog before save

  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Save word document with comments as pdf -- dialog before save

    I am trying to use vba to save a word document as a pdf file, the word document has comments in it.

    I am using the following code

    Please Login or Register  to view this content.
    It works well but the issue is before saving i get a message box saying "The document being saved contains comments. Continue with save?"


    How do I disable this or similar other messages OR by default have continue as my selection

    I want the macro to save the file as a pdf regardless if they have comments OR NOT.
    Last edited by chaliseyp; 10-12-2020 at 07:49 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Save file

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    78

    Re: Save file

    THanks alansidman for bringing the rules to my notice.

    I have amended the post to make the changes, hope it will be more readable now.

    I will endeavour to follow rules on the future.

  4. #4
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Save word document with comments as pdf -- dialog before save

    This in the beginning of your code:
    Please Login or Register  to view this content.
    and before MsgBox add:
    Please Login or Register  to view this content.
    This should do it.
    To show your appreciation
    Click ★ Add reputation!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 12-02-2019, 03:42 PM
  2. file save as tab delimited change to direct file save
    By bkanealy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2016, 02:15 PM
  3. save as which remains the master file and save new file
    By ash3angel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2015, 04:13 AM
  4. Macro needed to open "File Save As" and change save file type
    By blainerhett in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2014, 02:40 PM
  5. Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  6. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  7. Replies: 0
    Last Post: 03-09-2005, 06:06 PM

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