+ Reply to Thread
Results 1 to 6 of 6

Word Macro: Save document as PDF to specific folder with specific name

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    Belgium
    MS-Off Ver
    MS OFFICE 2013
    Posts
    3

    Word Macro: Save document as PDF to specific folder with specific name

    Hello,

    I'm new here, and i'm not an expert in VBA technology.

    But I need to make a lot of propositions in Word and save them in a specific folder with filename the number of the proposition.

    So I need to find a macro that can save word in PDF format, but it needs to take a Number from the document (propostion number) that is always on the same place, and use this as the filename. Also it needs to be stored in a specific folder.

    Please help me, it would save me so much time...

    With kind regards,

    Pete VH

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word Macro: Save document as PDF to specific folder with specific name

    From where do the data for these 'proposition' documents originate - a database, excel workbook, userform, something else? Are they all in one document that needs to be split up, or are they in separate documents?
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-10-2017
    Location
    Belgium
    MS-Off Ver
    MS OFFICE 2013
    Posts
    3

    Re: Word Macro: Save document as PDF to specific folder with specific name

    Hello,

    It's actually quotations that I make. Every quotation has a unique number like "20170001". So on every offer / quotation there is this number, and it's always on the same place in the document. This number should be also the filename of the PDF. Every document needs to be in 1 document.

    With kind regards,

    Pete VH

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word Macro: Save document as PDF to specific folder with specific name

    OK, but without knowing exactly where in your document the quote number is (e.g. 1st word in 1st paragraph, or 3rd cell in 1st row or second table, or a particular content control), I can't write code to retrieve it.

  5. #5
    Registered User
    Join Date
    05-10-2017
    Location
    Belgium
    MS-Off Ver
    MS OFFICE 2013
    Posts
    3

    Re: Word Macro: Save document as PDF to specific folder with specific name

    Dear,

    Thank you for your answer. It's always on the same place. Can you give me an example for like the 1st word in 1st paragraph? Then I can addapt it...

    With kind regards,

    Peter

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word Macro: Save document as PDF to specific folder with specific name

    Here's some code to get you started. It assumes the desired filename is in the first word in the first paragraph in the document and that you want to save the file to the user's 'Documents' folder. The first sub pops up a populated SaveAs dialogue; the second simply saves the file without prompting.
    Please Login or Register  to view this content.

+ 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. Word 2010 VBA save to specific folder as PDF
    By Coradia63 in forum Word Formatting & General
    Replies: 4
    Last Post: 01-29-2016, 06:17 PM
  2. Macro to print and save a document to specific folder with unique number
    By kasenga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 09:59 AM
  3. Button to save workbook, with value in specific cell (H5), in a specific folder
    By markeeny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2014, 01:15 PM
  4. Macro to break files and save with a specific word in the document.
    By adil.master in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2014, 04:37 PM
  5. Trying to save a Mail Merge word Document to a specific folder
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2014, 06:56 PM
  6. [SOLVED] MACRO Save in specific folder
    By forfiett in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2012, 02:53 PM
  7. [SOLVED] Macro to save workbook to specific folder with a specific name, then kill/disable itself.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2012, 03:50 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