Save Separate Payslips for every employee

[mscarrie]

Hi ,
Would like to seek your assistance so I can save a pdf file for every employee's payslip .Thank you

[jolivanes]

Where is the medical allowance in Payroll Sheet?
Is Travelling Allowance the same as Transportation?

[CEO76]

Try this

Please Login or Register  to view this content.

[mscarrie]

Hi jolivanes,
Oh no i forgot to edit that ,i will do that .I think i can manage to connect the payslip with the payroll ,it's just that we have 150 employees here ,and i want the payslip to generate and save the pdf everytime i change the employee number.

[mscarrie]

Ohhhh my Goshhh ! it does the job thank you so much ! what if i add up to 150 employees would it still save the pdf ?

[mscarrie]

Please Login or Register  to view this content.

I try editing it to make 10 to 30 ,but it does not work ? what would be the problem ?

[CEO76]

See the attached and this is a fixed for good...

[AliGW]

Administrative Note:

All participants please note!

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

CEO76 - you have been a member for a long time and should know the rules, so you need to amend your post yourself, please.

Mscarrie - as you are new, I have added the tags for you this time.

[CEO76]

Thanks AliGW for a good house keeping tip and standing firm on posting rule enforcement.

Cheers

CEO76

[AliGW]

And thank you for complying with my request.

[mscarrie]

Hi Ceo76,
Sorry for the inconvenience i have done ,i really salute you for this! Thank you .

[CEO76]

mscarrie - make this thread SOLVED if the solution is what you look for!

[mscarrie]

Just this last time Sir CEO76 ,since there was an adjustment for the payroll ,hopefully you may help me again . I have attached another file ,that would be the last , i tried to edit it ,but it was not the same .

[CEO76]

Solution is in the attached file. Mark it SOLVED if this is the right one!

[AliGW]

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

[jolivanes]

If you want to print PDF files for all the people in Column C of Payroll sheet in one go, this might be of help.
The macro can be run from either sheet, Payroll or Payslip.
I have not downloaded/opened any of the attachments, except your first one, so this might be a duplicate.
Try it and see if this is what you need
Change the folder or path where the PDF files will be saved before running the code.

Please Login or Register  to view this content.

[mscarrie]

oh sorry i i didn't know i am a beginner in macros that's why i really want it to see it in my excel worksheet .This would be the last thank you !

[jolivanes]

Make a Folder called "Payroll", without the double quotation marks, in your C drive so it looks like C:\Payroll
The PDF files for each person will be saved in that Folder.
If you want to save it in a different folder you will need to change the code to reflect this.

[mscarrie]

How will i tag this post solved ?