VBA Code to Automate Salary Slips

[@luisenc789]

Hi Abdul Nisar, I like the way you taught the vba portion. Very clear way to teach someone how to program. GREAT WORK!!!

[@Abdulnisar1]

Thank your brother, very interesting, especially the excel format you attached. Now can see the coding very clear.

[@12thAnalytics]

Thank you Abdul Nisar :-)

[@rinah3088]

Thanks for sharing this amazing video. However noticed on the VBA formula ....... Do While a

[@12thAnalytics]

Hi Rina. Thanks for your feedback. Its a good idea, I will update my video :-)

[@youtuberravi14]

using a

[@ariskavanessen7303]

Thank you for your great video.

[@12thAnalytics]

Hi Ariska Thank you for the feedback :-)

[@Rajan-kk8nl]

Very nice wonderfull. Thank you very much.

[@DavidAntwiBoasiako]

Thank you very much.

[@rakeshkumar-me2pv]

thank you very much very helpful

[@12thAnalytics]

Hi Rakesh Thanks for your feedback :-)

[@prasannareddy2603]

How u use vlookup function in dis

[@deepakkhanduri2714]

Thanks brother

[@aquibjaved6209]

This was really great.

[@PeggywongPeggy]

in spore workers they have OT claims split into 2 kind one is 1.5 hours and 2.0 hours if they come back to work during holiday is consider 2.0 hours how am i going to write the code

[@karuppusamyn515]

Sir, already i have created same in xls. I have generate pay slip keep the manual lookup value. Each sheet two pay slips fixed in my format. Now, how i can generate pay slip only selected employees ID numbers like 1000 to 1050 in pdf format. Kindly advise in another one video. I hope you. Thank, Regards, Karuppusamy N

[@busikukapikanya7706]

now how will it be stored for future use the payroll also how to send emails via gmail

[@ayantabujara1719]

Thanks for sharing this video. What if I want to print Emp1001-1005 only? How will I do it?

[@SubramanyanKP]

just change the line in the macro where it says "Do While a

[@ayantabujara1719]

okey I'll try, thanks.

[@karuppusamyn515]

Thank you sir... I have a salary slip in xls vlookup function. I have generated slip number wise copy paste option used. Now how I can save pdf in single button using macros

[@punyashlokahilyadeviholkar5019]

Nice explanation Sir ! I have used it and generated my pay slips but I need your help to regarding same.Please Help me.

[@PeggywongPeggy]

may I have the code

[@JK-hm3lf]

I want to do opposite. My task is to copy salary details of each employee and generate report containing the details of pays and allowances allocated for all employees in that month. The problem is, allowances and deductions are not in consective cells. Please share another video on generating report with details of salaries of all empolyees.

[@punyashlokahilyadeviholkar5019]

As per above pdf printout are generating with same name. How to change file name ? Please help me sir.

[@rkexcel2686]

next month ke kiye kya karana hoga kya baya data banana padega kuch aisa kijiye mant select karane par usi month ka data salect ho jaye

[@SureshBabu-kk6tn]

Can u help me how by entering employee code his details r changing???

[@rithveek]

Kindly try to make a complete payroll solution by making salary sheet in which we have to fill just no. of working days n salary for each month should automatically gets generated and also the payslip is generated by linking salary sheet of each month to it

[@12thAnalytics]

Hi Rithveek. Thanks for sharing the idea. Actually I was busy with some assignments. I will create such video in future.

[@AbdullaKhizamworld]

Can Anyone explain me save Xls and send Xls File not PDF?. This is Awesome post Btw

[@atulsahu2326]

could you please explain how to generate salary slips in ms access

[@atulsahu2326]

in pdf format

[@12thAnalytics]

Hi Atul. I will share a video soon on MS Access :-)

[@soohailakhtar]

Dear I am using this code to print Employees pay slips, Its really help me and save my time,... Please can you help me,,, I am using Letter size page to print pay slips I have over 800 slips , so its using lot of pages. Is there any way during printing 3 or 4 slips are printing on 1 page i.e Letter Size page, I am using printer Epson 2190,,, Thanks Sohail

[@peekaypk]

How can we code to create single file PDF of file containing year Salary Slip in for 1 EMP Pls help if possible

[@12thAnalytics]

Hi Pradeep! So, basically you want one PDF file for all Salary Slips??

[@peekaypk]

Yes

[@globalfoundry2912]

is their any way to whatsapp the salary slip ??? Via whatsapp desktop ???

[@SubramanyanKP]

A Salary Slip is a confedential information and not worth sharing through whatsapp and email ids like google and yahoo..

[@12thAnalytics]

Hi Global Foundry. You can use gmail, yahoo etc but if you have desktop version of WhatsApp you can send it.

[@mukundnirmal7667]

Sir aap ki avaj slow hai please video teg avag ki video bheje please sir jaror bheg dena sir

[@raghuram45]

Hi If we use alphabets with Employee Id for Ex: ABC001 OR ADCD1000. how to enter the value instead of 1001. please help

[@youtuberravi14]

you can use serial no.

[@raghuram45]

Raviish14 please help me with correct coding I already mailed you from [e-mail]

[@youtuberravi14]

Download file and change employee ID and it will work with same coding

[@juskonig]

The sound on this video is urribble :(

[@12thAnalytics]

Hi Justin. Thanks for the feedback. I know the poor quality of voice. Actually I created these videos as a fun using a third class handfree. In future, It will be awesome :-)