Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-25-2018, 11:20 AM
loki005 loki005 is offline Save all docs to pdf in specified folder Windows 10 Save all docs to pdf in specified folder Office 2013
Novice
Save all docs to pdf in specified folder
 
Join Date: Oct 2018
Posts: 3
loki005 is on a distinguished road
Default Save all docs to pdf in specified folder

Hello there,



I need to be able to save all documents in a specified folder, while retaining those documents original file names.

Note: I read previously where someone was having issues with emailing the saved pdfs thereafter, but wasn't able to figure out what was done to correct that issue. As I haven't gotten to that point yet, I am not certain about the issue with emailing the pdfs after the fact, but I can say that I will need to be able to email the pdf documents after they have been saved/converted from another doc type

Code:
Code:
Sub AcceptSave()
'
' AcceptSave Macro
'
'
ActiveDocument.AcceptAllRevisions
ActiveDocument.TrackRevisions = False
Application.Run MacroName:="Silent_save_to_PDF"
ActiveDocument.Save
End Sub
 
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
Thank you.
Reply With Quote
 

Tags
loop, save as pdf, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Save all docs to pdf in specified folder Run macro to save multiple word docs and xml Prateep Nath Word VBA 1 02-05-2018 02:52 PM
Save all docs to pdf in specified folder Macro to save as pdf with ability to choose save as folder rvessio Word VBA 4 07-25-2016 12:37 PM
Save all docs to pdf in specified folder Import a specific range (bookmarked section) from all Word docs in a selected folder Greengecko Word VBA 5 06-14-2016 07:54 AM
Save all docs to pdf in specified folder Word always brings up 'Save As' dialogue when I try to Save - same for all Word docs stuartb Word 1 08-18-2014 12:26 PM
Save all docs to pdf in specified folder HELP: Microsoft Office won't save docs. Pjbarasi Word 1 01-18-2012 04:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft