Need help on how to convert excel to pdf for payslip project please

Need help on how to convert excel to pdf for payslip project please

2 Likes

you can do this with 2 lines of code in vba

1 Like

Cod is
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FullPath & FileName With Extension is .pdf, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=Tue

2 Likes

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

1 Like

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.

  1. Open Excel file.
  2. Ensure each payslip is in a separate sheet.
  3. Go to FilePrint, choose a PDF printer, and save.

Online Converter:

  1. Choose a platform like SmallPDF.
  2. Upload your Excel file.
  3. Follow instructions to convert and download the PDF.