In this video, 12th Analytics will show you how to prepare salary slips using VBA Macro in Excel and get print out of all the slips on a single click. Excel file is available at drive.google.com/open?id=0B8Q...
Пікірлер: 53
@luisenc7893 жыл бұрын
Hi Abdul Nisar, I like the way you taught the vba portion. Very clear way to teach someone how to program. GREAT WORK!!!
@Abdulnisar17 жыл бұрын
Thank your brother, very interesting, especially the excel format you attached. Now can see the coding very clear.
@12thAnalytics6 жыл бұрын
Thank you Abdul Nisar :-)
@aquibjaved62093 жыл бұрын
This was really great.
@ariskavanessen73037 жыл бұрын
Thank you for your great video.
@12thAnalytics6 жыл бұрын
Hi Ariska Thank you for the feedback :-)
@DavidAntwiBoasiako3 жыл бұрын
Thank you very much.
@Rajan-kk8nl3 жыл бұрын
Very nice wonderfull. Thank you very much.
@deepakkhanduri27146 жыл бұрын
Thanks brother
@PeggywongPeggy4 жыл бұрын
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
@karuppusamyn5154 жыл бұрын
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
@karuppusamyn5153 жыл бұрын
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
@rakeshkumar-me2pv7 жыл бұрын
thank you very much very helpful
@12thAnalytics6 жыл бұрын
Hi Rakesh Thanks for your feedback :-)
@prasannareddy26036 жыл бұрын
How u use vlookup function in dis
@busikukapikanya77064 жыл бұрын
now how will it be stored for future use the payroll also how to send emails via gmail
@rinah30886 жыл бұрын
Thanks for sharing this amazing video. However noticed on the VBA formula ....... Do While a
@12thAnalytics6 жыл бұрын
Hi Rina. Thanks for your feedback. Its a good idea, I will update my video :-)
@youtuberravi146 жыл бұрын
using a
@SureshBabu-kk6tn4 жыл бұрын
Can u help me how by entering employee code his details r changing???
@punyashlokahilyadeviholkar50194 жыл бұрын
Nice explanation Sir ! I have used it and generated my pay slips but I need your help to regarding same.Please Help me.
@punyashlokahilyadeviholkar50194 жыл бұрын
As per above pdf printout are generating with same name. How to change file name ? Please help me sir.
@rkexcel26865 жыл бұрын
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
@JK-hm3lf5 жыл бұрын
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.
@ayantabujara17197 жыл бұрын
Thanks for sharing this video. What if I want to print Emp1001-1005 only? How will I do it?
@SubramanyanKP7 жыл бұрын
just change the line in the macro where it says "Do While a
@ayantabujara17197 жыл бұрын
okey I'll try, thanks.
@PeggywongPeggy4 жыл бұрын
may I have the code
@AbdullaKhizamworld5 жыл бұрын
Can Anyone explain me save Xls and send Xls File not PDF?. This is Awesome post Btw
@soohailakhtar5 жыл бұрын
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
@rithveek7 жыл бұрын
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
@12thAnalytics6 жыл бұрын
Hi Rithveek. Thanks for sharing the idea. Actually I was busy with some assignments. I will create such video in future.
@atulsahu23267 жыл бұрын
could you please explain how to generate salary slips in ms access
@atulsahu23267 жыл бұрын
in pdf format
@12thAnalytics6 жыл бұрын
Hi Atul. I will share a video soon on MS Access :-)
@peekaypk6 жыл бұрын
How can we code to create single file PDF of file containing year Salary Slip in for 1 EMP Pls help if possible
@12thAnalytics6 жыл бұрын
Hi Pradeep! So, basically you want one PDF file for all Salary Slips??
@peekaypk6 жыл бұрын
Yes
@globalfoundry29127 жыл бұрын
is their any way to whatsapp the salary slip ??? Via whatsapp desktop ???
@SubramanyanKP7 жыл бұрын
A Salary Slip is a confedential information and not worth sharing through whatsapp and email ids like google and yahoo..
@12thAnalytics6 жыл бұрын
Hi Global Foundry. You can use gmail, yahoo etc but if you have desktop version of WhatsApp you can send it.
@raghuram456 жыл бұрын
Hi If we use alphabets with Employee Id for Ex: ABC001 OR ADCD1000. how to enter the value instead of 1001. please help
@youtuberravi146 жыл бұрын
you can use serial no.
@raghuram456 жыл бұрын
Raviish14 please help me with correct coding I already mailed you from raghuram49@gmail.com
@youtuberravi146 жыл бұрын
Download file and change employee ID and it will work with same coding
@mukundnirmal76675 жыл бұрын
Sir aap ki avaj slow hai please video teg avag ki video bheje please sir jaror bheg dena sir
@juskonig7 жыл бұрын
The sound on this video is urribble :(
@12thAnalytics6 жыл бұрын
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 :-)