Excel VBA Macro To Save Each Sheet in ThisWorkBook as a PDF File
'This Macro Prints Each sheet of Thisworkbook[i.e. The workbook in which you use this macro code].
'If you want to run this macro on any Active Work Book , Please edit as required.
Sub PrintMyWorkbook2Pdf()
Dim WB As Object
Dim WS As Worksheet
Dim MyFilePath As String
Dim PdfFileName As String
Dim PdfFilesFolder As String
On Error Resume Next
Set WB = ThisWorkbook
PdfFilesFolder = ThisWorkbook.Name & "_" & "PDFs"
MyFilePath = "C:\Documents and Settings\Administrator\My Documents\"
MkDir MyFilePath & PdfFilesFolder & "\"
PdfFileName = ActiveSheet.Name
For Each WS In WB.Sheets
WS.Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
FileName:=MyFilePath & PdfFilesFolder & "\" & ActiveSheet.Name, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
Next WS
End Sub
Note:
The Macro Replace the Previous Pdf Files with the Latest Files Every Time You Run
Thanks,Tamatam
'This Macro Prints Each sheet of Thisworkbook[i.e. The workbook in which you use this macro code].
'If you want to run this macro on any Active Work Book , Please edit as required.
Sub PrintMyWorkbook2Pdf()
Dim WB As Object
Dim WS As Worksheet
Dim MyFilePath As String
Dim PdfFileName As String
Dim PdfFilesFolder As String
On Error Resume Next
Set WB = ThisWorkbook
PdfFilesFolder = ThisWorkbook.Name & "_" & "PDFs"
MyFilePath = "C:\Documents and Settings\Administrator\My Documents\"
MkDir MyFilePath & PdfFilesFolder & "\"
PdfFileName = ActiveSheet.Name
For Each WS In WB.Sheets
WS.Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
FileName:=MyFilePath & PdfFilesFolder & "\" & ActiveSheet.Name, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
Next WS
End Sub
Note:
The Macro Replace the Previous Pdf Files with the Latest Files Every Time You Run
Thanks,Tamatam
No comments:
Post a Comment
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.