Thread: [Solved] problem with excel to pdf macro
View Single Post
 
Old 07-12-2018, 04:35 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Have you tried
Code:
'Print Selected Sheets to PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fPath & fName, _
     IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
Reply With Quote