#Excel #ExcelVBA #Payrolltraining #iptmnoida
In this video, you will learn how to convert Excel sheet in PDF using VBA code. I have linked a Salary slip format with row data of payroll employee and made it dynamic once serial number changed in row number A1.
Code and Sheet download link:
Keywords:
excel to pdf formula, excel to pdf vba, excel to pdf converter free, microsoft excel to pdf add-in, excel to pdf landscape mode, export excel to pdf landscape vba, convert excel to pdf landscape format, convert excel to pdf multiple sheets, save excel to pdf all sheets, export excel to pdf all sheets, convert excel to pdf all sheets, excel to pdf multiple sheets, save excel to pdf in landscape, excel to pdf all sheets, excel to pdf multiple files, excel to pdf in landscape, excel to pdf converter free download nitro, how do i convert excel to pdf landscape….(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Protect multiple pdf files at once with different passwords from Excel automatic | using VBA macro
https://youtu.be/5qA2uGLfmGE
Your code is not working, in your sheet it will not work
Not working
Sub Create_PDF()
Dim Foldername, Filename, PDFPath, SR
Foldername = "C:UsersGEOMATICSDesktopEXCEL TO PDF" ' Change it
For SR = 1 To 2
Sheets("Pay Slip").Range("A1").Value = SR
Filename = Sheets("Pay Slip").Range("H7").Value
PDFPath = Foldername & "" & Filename & ".pdf"
Sheets("PayRegister").Visible = False
ActiveSheet.ExportAsFixedFormat xlTypePDF, PDFPath, xlQualityStandard, False
Sheets("PayRegister").Visible = True
Next SR
MsgBox "Successfully Saved"
End Sub
Error ( run time error 5 , invalid cell or argument)
ActiveSheet.ExportAsFixedFormat xlTypePDF, PDFPath, xlQualityStandard, False
Sir
Mujhe salary sheet se kuchh details sabhi employee ko bhena hai WhatsApp PE pdf to uska chords bhejiye
Pdf file not generate…
Very short & simple code….Thank you so much……
How to convert all pdf in one file how to convert sir because I am your subscriber
How to export charts along with data to pdf
Hai ,when I click on Run I got "saved successfully" messages but PDF files not generated….kindly help me ….I need …
Sir I am facing error issue on code
Run time error '5'
invalid procedure call or argument
On this line
Active workbook.ExportAsFixedFormet xlTypePdf, PDFPath, xlQualityStandard, False
hi Sir, I am get Code problem, Pls Help, pls send xls file to my email Id shaikh_pz@yahoo.com
My Whatsapp number
7899901329
Thank u very much for toturial, brother how can we send created pdf payslips to employees via email.
Sir Is it possible to save all of them with the single pdf?
I am facing a problem with the code sir
"Invalid procedure call or argument" sir
hey, very useful video, please share me your email id , please
Thank you sir….such a helpful video.
From where I can get your VBA video
Thanks sir
Superb
Superb
Thank you sir
too good for us, thanks to share this video
Good video