Automate payslip in PDF on one click in Excel

[@spreadthehappiness695]

Literally great ..!! Thanks to you SIR

[@basheerkhan6742]

Thank you!

[@HajiBashir13]

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

[@samarumbreen5106]

wow my problem is solved thanks and keep it up

[@basheerkhan6742]

Thank you!

[@miki_5914]

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

[@anups2122]

its awesome some i followed as suggested and its working fine

[@basheerkhan6742]

Thank you!!

[@mnds9598]

Thank you so much sir!!

[@basheerkhan6742]

you are welcome

[@financetips]

Thank you …good video

[@basheerkhan6742]

you are welcome

[@bahadinsaeed4947]

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]

Hi, please send me the file and let me check [e-mail]

[@shalumagan]

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

[@basheerkhan6742]

Hi, please send me the file and let me check [e-mail]

[@basheerkhan6742]

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

[@miki_5914]

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

[@basheerkhan6742]

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 [e-mail]

[@miki_5914]

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

[@padhumaisworld4987]

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]

Please send me a screen shot to understand the issue

[@basheerkhan6742]

or email me at [e-mail]

[@syedshahzaib5032]

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

[@isaacboye6803]

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

[@syedshahzaib5032]

did you find the solution?

[@VartikaTiwari-v6q]

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]

HI, please send me your file , let me see the issue to fix it. email: [e-mail]

[@mr_kpexor]

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

[@basheerkhan6742]

send me your file at [e-mail], let me check

[@basheerkhan6742]

Hi, please send me the file and let me check [e-mail]

[@RamK-x5q]

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]

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

[@basheerkhan6742]

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

[@COLLINSCHISOYA-ux9td]

Kindly share the sàmple of this

[@ashishpuri-mh9lg]

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

[@ashishpuri-mh9lg]

Plz upload one video on it

[@basheerkhan6742]

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

[@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.

[@nmishurentertainment7438]

বাংলায় কিভাবে