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
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
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.
Literally great ..!! Thanks to you SIR
Thank you!
❤❤❤ماشاءاللہ❤❤❤
wow my problem is solved thanks and keep it up
Thank you!
Thank you very much i will try it hope i am successfull. newbie here, never try macro before
its awesome some i followed as suggested and its working fine
Thank you!!
Thank you so much sir!!
you are welcome
Thank you …good video
you are welcome
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
Hi, please send me the file and let me check bashkhannew@hotmail.com
Thanka for the detailed info. I am facing an error while clicking on printpdf. How to solve it?
Hi, please send me the file and let me check bashkhannew@hotmail.com
You might be using some other name of the sheet, or syntax errorr.
Sir, if only the employee id that change in my pdf file. what is the problem?
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
Can you please make a tutorial how to sent the pay slip by email from excel file sir? Thank you in advance
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
Please send me a screen shot to understand the issue
or email me at bashkhannew@hotmail.com
how do we email the individual pay slips to the employees?
Thanks Sir. How do I email the payslip to the employee automatically?
did you find the solution?
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
HI, please send me your file , let me see the issue to fix it. email: bashkhannew@hotmail.com
I'm having a problem with my VBA code its giving me a run time error
send me your file at bashkhannew@gmail.com, let me check
Hi, please send me the file and let me check bashkhannew@hotmail.com
How to protect the generated salary slip with password? The password can be , for example, the employee's PAN
This is posible bu you need to install a 3rd party software.
Sir how about if i want to name pdf employee name along with employee id
Yes it is possible, you can name he employee name as pdf
Kindly share the sàmple of this
Sir instead of emp. id hiw to save with emp.name
Plz upload one video on it
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
kindly share the sample file
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.
বাংলায় কিভাবে