Sub createPDFfiles() Dim ws As Worksheet Dim Fname As String For Each ws In ActiveWorkbook.Worksheets On Error Resume Next 'Continue if an error occurs Fname = "Annex 1.1." & ws.Index & "_result" Fname = "C:\pdfs\" & ActiveWorkbook.Name & "-" & ws.Name ws.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=Fname, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False Next ws End Sub
ورود به سایت