![]() |
|
#1
|
|||
|
|||
![]()
Hi all! The macro below does a great job of saving a PDF (and overriding changes) to the same original location where the Word document lives, but how can I tell it to save to a specific location on my network?
The purpose of this would be to distribute the Word doc to colleagues in various departments and have them all save a PDF version of the working doc in a specific folder, each overriding a previous PDF: Sub Silent_save_to_PDF() ' ' Silent Save_to_PDF Macro ' ActiveDocument.ExportAsFixedFormat OutputFileName:= _ Replace(ActiveDocument.FullName, ".docx", ".pdf"), _ ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, OptimizeFor:= _ wdExportOptimizeForPrint, Range:=wdExportAllDocument, Item:= _ wdExportDocumentContent, IncludeDocProps:=False, KeepIRM:=True, _ CreateBookmarks:=wdExportCreateNoBookmarks, DocStructureTags:=True, _ BitmapMissingFonts:=True, UseISO19005_1:=False End Sub Many thanks! |
#2
|
||||
|
||||
![]()
Change:
Replace(ActiveDocument.FullName, ".docx", ".pdf") to: "Some Path\" & Replace(ActiveDocument.Name, ".docx", ".pdf") where 'Some Path' is the designated path.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rvessio | Word VBA | 4 | 07-25-2016 12:37 PM |
Macro Needed to bold specific lines and Macro to turn into CSV | anewteacher | Word VBA | 1 | 05-28-2014 03:59 PM |
![]() |
ximpostor | Word VBA | 10 | 10-12-2012 12:35 PM |
can I run a macro when I open a specific doc. | shreked | Word | 8 | 01-12-2012 03:36 AM |
Macro Location | eliz.bell | Word | 0 | 10-05-2009 07:44 PM |