How to generate payslip and print it all at once

**macnabong** · 07-09-2014, 10:58 PM

I need to print an employees payslip:

I have already created a template of payslip in a worksheet and the payslip is generated using drop down menu of employee name and vlookups.

Now i want them to print the payslip of all employees listed on the dropdown list all at once, instead of selecting a name then print.

also the filename should be based on the employee name, and it should directly print, no more interaction.

In short, when i click a the print button all payslip will be generated to a certain folder.

Thanks in advanced!!!

**JBeaucaire** · 07-10-2014, 02:36 AM

CYCLE THROUGH DV OPTIONS
Here's a basic macro for cycling through all the Data Validation options in a certain cell. The sample then prints out the workbook, but you can replace that line of code with whatever action you prefer, this should give you the basics.
Cycle Through Data Validation Options

The one edit that comes to mind is instead of printing the payslips (which may work for you and you're done..) you can export the sheet to PDF using the same cell reference as a filename source...

so this line:

    ActiveSheet.PrintOut                        'do something here...

...is replaced by something like this:

    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
        Filename:="C:\MyDocuments\Payslips\" & Range("B1").Value & "temp.pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, OpenAfterPublish:=False