Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub VbaPdf()
  2.     Dim i As Integer
  3.     For i = 1 To Worksheets.Count
  4.         If Worksheets(i).Name = "Start" Then
  5.             'Vi vil ikke printe Start
  6.        Else
  7.             Worksheets(i).ExportAsFixedFormat Type:=xlTypePDF, FileName:=Application.ActiveWorkbook.Path & "/" & Worksheets(i).Name & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
  8.         End If
  9.     Next i
  10. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement