Thread: [Solved] Save As PDF from UserForm Issue
View Single Post
 
Old 09-20-2014, 05:14 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
I modified the PDF module so that it should now save to the same folder as the document, unless you are using the document as a template in which case the new document won't have a path. If you are doing that either save the document first, or change the line
strFilename = ActiveDocument.Path & _
to
strFilename = ThisDocument.Path & _
which will save the PDF in the same folder as the 'template'.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote