hi all,
I have the code below that saves the worksheet as a pdf. it saves it to My Documents as default, how do I change it to save to a specific destination?
thanks in advanceSub SaveSheetsAsPDF() Dim ss As Worksheet For Each ss In ActiveWorkbook.Worksheets ss.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ss.Range("E7") Next ss End Sub
Bookmarks