Need help on how to convert excel to pdf for payslip project please
you can do this with 2 lines of code in vba
Cod is
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FullPath & FileName With Extension is .pdf, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=Tue
Thank you so much it was very useful
Please also help me on how to send individual mail to individual employess using zoho account
From-To Zoho Account
1.Excel to pdf
2.PDF in one Folder
3.One Folder one PDF to ZOHO Email Account
Sorry for late reply ! Just confirmation i think solution provided from our end on this @Maya_Bharani
hello,
Certainly! Converting an Excel file to PDF for a payslip project can be done in several ways. I’ll outline two common methods: using Microsoft Excel itself and using an online converter.
- Open Excel file.
- Ensure each payslip is in a separate sheet.
- Go to
File
→Print
, choose a PDF printer, and save.
Online Converter:
- Choose a platform like SmallPDF.
- Upload your Excel file.
- Follow instructions to convert and download the PDF.