+ Reply to Thread
Results 1 to 6 of 6

payslip printing through macros

Hybrid View

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    payslip printing through macros

    Hi Friends,
    I want to print payslips automatically through macros .All payslips should get printed automatically.
    I am attaching the sample sheet also pls formulate it.I will be highly greatfull.

    Thanks in advance
    aparna wangu
    Attached Files Attached Files

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    511

    Re: payslip printing through macros

    have a look at this

    http://www.excelforum.com/excel-prog...eneration.html

  3. #3
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Re: payslip printing through macros

    Hi thanks for providing such an useful info but i am very new to VBA as well as macros and i am not able to recognize in demo macro sheet that how to implement the same in my payslip sheet as the cell references will be different.Pls guide me i am really confused.I want that all the payslips should should get stored in pdf file and then i can print the same file.Pls populate the sheet with formulas. I will be highly greatfull.

    Thanks in advance.

  4. #4
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: payslip printing through macros

    First, you have to enable Macros on your worksheet.
    File > Options > Customize Ribbon > (check-box) Developer

    Second, when you save, you have to make sure it's a Macro-Enabled excel file.
    File > Save As > [Enter file name] > [Save as type] Excel Macro-Enabled Workbook

    Now, this is just a super-basic answer to what you've asked for. The only thing that should be changed, on Sheet2, is the cell C4, which is the Employee ID number. Every other space that does something, looks at that cell on the Sheet1 table and fills in the appropriate information.

    If you need to look at the VBA programming, select your sheet:
    View > Macros > [choose one] Edit
    As you can see on PrintAll, it's just a repeating, so you should be able to copy/paste for your information. I labeled all I could think of to help explain it.

    Edit - I don't know how to save to the pdf format, like you wanted, but this populates the Sheet2 and prints one or all, however you choose.
    Last edited by Old4xford; 07-09-2015 at 03:13 PM. Reason: Forgot pertenant information
    Oh! I get it. I need rep--->҉

  5. #5
    Registered User
    Join Date
    07-06-2015
    Location
    India
    MS-Off Ver
    PC 2016
    Posts
    87

    Re: payslip printing through macros

    Thank You Thank You Thank You so much.I really appreciate your help.This has resolved a big headache of mine.
    Thanks
    I want a help actually i add two more lines in payslip but that is not reflecting in the print out.Pls help me out.
    One more thing i want a combobox in empid so that i can select the ids from that and print accordingly.
    Last edited by aparnawangu; 07-10-2015 at 01:10 AM.

  6. #6
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: payslip printing through macros

    On the example sheet, I restricted the Print Area on the payslip page, for testing purposes. I guess I forgot to remove the restriction. To do that, do the following:
    Page Layout (tab) > Print Area > Clear Print Area

    i want a combobox in empid so that i can select the ids from that and print accordingly.
    I'm not really sure what you mean. Are you asking for a Drop-down list?
    Click on the Cell you want the list to appear >
    Data (tab) > Data Validation > Allow:List ; Source:Sheet1!A2:A5 (of the example given) > Ok

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macros for Payslip Generation
    By MACLARKE in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-04-2015, 12:29 PM
  2. [SOLVED] HOW to prepare payroll in macros and generate payslip in EXCEL 2003
    By sysen_aee in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-21-2014, 06:39 AM
  3. Replies: 2
    Last Post: 04-04-2013, 07:27 AM
  4. Payslip Printing & Error while Wrong Emp Code
    By koolguys4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2010, 02:45 PM
  5. Printing using macros
    By primero in forum Excel General
    Replies: 1
    Last Post: 08-21-2009, 02:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1