Have you ever created a PDF from a Sheet in Excel? Easy isn't it?
Creating PDF files from sheets in Excel is an easy job. What if in the Excel file there are lots of sheets. For example, a report from sales in one month for each excel file consisting of 30 days, where each day's report is stored in a different sheet. Or maybe each excel file contains hundreds of sheets and you have to create a PDF file of each sheet.
Pekerjaan yang mudah menjadi berat jika volumenya sangat besar. Tapi tidaEasy work becomes heavy if the volume is very large. But don't worry, using macros from Excel will not be a problem.
Other Interesting Articles
Export Excel sheet to PDF with Macro VBA
- Open Excel Macros, see how to create macros.
- Copy the following script
Sub ExportToPDFs()
' Bardimin
' Export Sheet to PDF
' Save Each Worksheet to a separate PDF file.
Dim ws As Worksheet
Dim myFile As String
myFile = Application.ActiveWorkbook.Path
For Each ws In Worksheets
ws.Select
sheetName = ws.Name
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=myFile & "" & sheetName & ".pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
Next ws
End Sub
- Run Macro
The macro export sheet to PDF will produce a PDF file with a name like a sheet name in Excel that you created and saved in the directory from the same as your excel file.
To change the name of the resulting PDF file, you can change the following line of code
Filename:=myFile & "" & sheetName & ".pdf", _
Good luck ……