Automate payslip in PDF on one click in Excel

Рет қаралды 9,001

Жыл бұрын

A simple example of making a small automated printable payslip, this is simple format which can be converted the available design automatically to PDF, even within a simple VBA loop going to repeat automatically and convert all records to PDF. #payslip #automatedpayroll
#convertexceltopdf #pdf #excel #excelfunctions #functions #microsoft #exceltraining #microsoftexceltips #msexcel #exceltips

Пікірлер: 36

@HajiBashir13 Ай бұрын

❤❤❤ماشاءاللہ❤❤❤

@financetips 25 күн бұрын

Thank you …good video

@basheerkhan6742 24 күн бұрын

you are welcome

@miki_5914 3 ай бұрын

Thank you very much i will try it hope i am successfull. newbie here, never try macro before

@samarumbreen5106 Жыл бұрын

wow my problem is solved thanks and keep it up

@basheerkhan6742 Жыл бұрын

Thank you!

@anups2122 9 ай бұрын

its awesome some i followed as suggested and its working fine

@basheerkhan6742 7 ай бұрын

Thank you!!

@syedshahzaib5032 5 ай бұрын

how do we email the individual pay slips to the employees?

@bahadinsaeed4947 10 ай бұрын

thanks for detailed explanation , I repeat the code according to my scenario but it tells me the "variable not defined" and it highlights a . in which in my case a= 5 to 39 kindly advise how to solve this issue. thanks in advance

@basheerkhan6742 7 ай бұрын

Hi, please send me the file and let me check bashkhannew@hotmail.com

@miki_5914 3 ай бұрын

Can you please make a tutorial how to sent the pay slip by email from excel file sir? Thank you in advance

@user-xh7oy7nn9o Жыл бұрын

How to protect the generated salary slip with password? The password can be , for example, the employee's PAN

@basheerkhan6742 Жыл бұрын

This is posible bu you need to install a 3rd party software.

@anups2122 9 ай бұрын

Sir how about if i want to name pdf employee name along with employee id

@basheerkhan6742 6 ай бұрын

Yes it is possible, you can name he employee name as pdf

@shalumagan 8 ай бұрын

Thanka for the detailed info. I am facing an error while clicking on printpdf. How to solve it?

@basheerkhan6742 7 ай бұрын

Hi, please send me the file and let me check bashkhannew@hotmail.com

@basheerkhan6742 6 ай бұрын

You might be using some other name of the sheet, or syntax errorr.

@miki_5914 2 ай бұрын

Sir, if only the employee id that change in my pdf file. what is the problem?

@basheerkhan6742 2 ай бұрын

Hi @miki, i didn't get what you are saying, send me the macro code, so i can see that what is the problem. send me on bashkhannew@hotmail.com

@isaacboye6803 5 ай бұрын

Thanks Sir. How do I email the payslip to the employee automatically?

@syedshahzaib5032 5 ай бұрын

did you find the solution?

@padhumaisworld4987 3 ай бұрын

I'm getting error as macros disabled for this excel even after macro settings changed and file saved as macro excel book pl advise what to do

@basheerkhan6742 3 ай бұрын

Please send me a screen shot to understand the issue

@basheerkhan6742 3 ай бұрын

or email me at bashkhannew@hotmail.com

@mr_kpexor Жыл бұрын

I'm having a problem with my VBA code its giving me a run time error

@basheerkhan6742 Жыл бұрын

send me your file at bashkhannew@gmail.com, let me check

@basheerkhan6742 7 ай бұрын

Hi, please send me the file and let me check bashkhannew@hotmail.com

@saravanankumar4297 Жыл бұрын

kindly share the sample file

@basheerkhan6742 Жыл бұрын

Dear Saravan, the idea of these video is to teach in a simple way, first please try it by yourself to create it, then if you face any problem then please let me know.

@user-nh1ff6qt9w 4 ай бұрын

HELLO SIR, i AM FACING PROBLRM IN APPLYING VLOOKUP FORMULA IN SAME DATA ITS SHOWING NA....CAN YOU PLEASE SHARE YOUR SALARY DATA AND Salary slip file

@basheerkhan6742 4 ай бұрын

HI, please send me your file , let me see the issue to fix it. email: bashkhannew@hotmail.com

@ashishpuri-mh9lg 6 ай бұрын

Sir instead of emp. id hiw to save with emp.name

@ashishpuri-mh9lg 6 ай бұрын

Plz upload one video on it

@basheerkhan6742 6 ай бұрын

OK, please name the cell which have employee name to "EmpName" and write the below code Sheet2.ExportAsFixedFormat xlTypePDF, "D:\PaySlip\" & Sheet2.Range("EmpID") & " - " & Sheet2.Range("EmpName").Value & ".pdf", , , False, , , False