Automate printing Payslips and Salary slips

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ต.ค. 2024
  • How to design an Excel Template that can print the Salary slips for 1000s of Employees is explained in this video.
    VBA code for English Number can be found at the following webpage.
    xlncad.com/mac...
    If you find my videos useful and like to show your ❤️ and support, buy me Coffee☕
    www.buymeacoff...
    🍐Join my online course on Excel Tables
    www.udemy.com/...
    🍓Download my free eBook on Excel Macros
    eepurl.com/gpT0RD
    🍇Check these Books on Excel
    xlncad.com/exc...
    🍉Read my articles on Excel
    xlncad.com/
    🍏Playlist for Shorts on Excel
    • Short videos on Excel ...
    #payslip #payroll #payrollsoftware

ความคิดเห็น • 25

  • @RanjitSingh-jx2pd
    @RanjitSingh-jx2pd ปีที่แล้ว

    Nice to meet you yesterday at the bus station. Keep up the good work

  • @TritonConsultancy-iz1gf
    @TritonConsultancy-iz1gf 3 หลายเดือนก่อน

    Really really appreciate your effort. This is superb.
    Is there any way to connect their attendance ledger of the month along with payslip ...? Please make a video on it as well

  • @teangvanny3270
    @teangvanny3270 หลายเดือนก่อน

    So Appreciation your sharing, May u share this workbook. Thanks

  • @chandanv646
    @chandanv646 ปีที่แล้ว +1

    Sir
    Really appreciated for your work
    Pls include mail functionality from this Excel page itself so after generation Payslips are mailed to employees

  • @mtlwgm
    @mtlwgm ปีที่แล้ว

    This is so helpful. Could you please also upload a video about formatting bank statement with macro VBS too? thanks

  • @nurnatasha5391
    @nurnatasha5391 2 หลายเดือนก่อน +1

    Thank you, it make easy to print

  • @brightagbenyo678
    @brightagbenyo678 ปีที่แล้ว

    Really appreciated the good work you have been doing.
    Please, How do you create payslips and insert the following on the dashboard
    1. Home
    2. Validate
    3. certify PV
    4. feedback
    5. message
    6. Generate code
    7. change Password
    8. Validate Image
    Hope my request will be considered

  • @venup1728
    @venup1728 หลายเดือนก่อน

    Sir,
    Am getting automation error as below. can you please suggest
    "The file name, directory name, or volume label syntax is incorrect"
    I have coded as said in the video - "Filename:="C:\121\" + Empid + ".pdf", _"

  • @shirleygoh3051
    @shirleygoh3051 ปีที่แล้ว

    The PrintALLPayslip button will print all the rows of records. What will be the VBA code if my listing contains all 12 months' records but I only want to print one selected month for all employees? Can advice?

  • @miki_5914
    @miki_5914 5 หลายเดือนก่อน

    On print payslip module 'month as string' not used. Is it possible to delete the code from module?

  • @sandeshbapu1567
    @sandeshbapu1567 3 หลายเดือนก่อน

    Please let me know, how can we overwrite the PDF which is already saved with Prompt

  • @RAMGAUR
    @RAMGAUR ปีที่แล้ว

    Sir will u help me for make a Excel formula for time increase decrease spin button

  • @sanjeevAggarwal29
    @sanjeevAggarwal29 ปีที่แล้ว

    Thanks for sharing awesome video. Is it possible to print all payslips to a single pdf file instead of individual names ?

    • @dattanandl
      @dattanandl ปีที่แล้ว

      All these pdf can be merged using Nitro is it?

  • @tutingrubena1584
    @tutingrubena1584 6 หลายเดือนก่อน

    How about printing multiple payslips on 1 sheet of paper?

  • @quincyirang2543
    @quincyirang2543 9 หลายเดือนก่อน

    Sir I have problem
    How can I count date exclude same date
    example. the activity is happen on 1 jan 2023, 2 Jan 2023, 3 jan 2023 is equal to 3
    but how to count if the actiitivy happen on the same date but I dont want to count
    example. the activity is happen on 1 jan 2023, 1 Jan 2023, 3 jan 2023 is equal to 2
    please help me

  • @thomascharbine7316
    @thomascharbine7316 6 หลายเดือนก่อน

    Hi. I followed your instructions very carefully and all went well until when I had to run the 1st Modulle in Visual Basic. It is giving an error message- Run-time error 1004: document not saved. Any helpful tips on how to solve this matter?

    • @lornarivera2378
      @lornarivera2378 5 หลายเดือนก่อน

      Had the same problem when I run the macro....how do I fix this?

  • @bhavneshparikh8283
    @bhavneshparikh8283 ปีที่แล้ว

    how to download this file?

  • @sc5163
    @sc5163 9 หลายเดือนก่อน +1

    How to print 4 salary slips in one page?

  • @BlackMarkerSir
    @BlackMarkerSir ปีที่แล้ว +1

    First one

  • @tutingrubena1584
    @tutingrubena1584 6 หลายเดือนก่อน

    vlook up just keeps on #NA the name cell on mine

  • @mustasimarif7708
    @mustasimarif7708 6 หลายเดือนก่อน

    I bro I want to purchase from BD could you share your Bkash Number?