The Study Secretz

According to the Code of Wages, 2019, the basic pay of an employee has to be 50 per cent of the total CTC. Find out which employees will benefit most from the implementation of the new wage code: The government may soon notify the new wage code rules that will lead to a change in the salary structure for a large number of employees in the country. According to the Code of Wages, 2019, the basic pay of an employee has to be 50 per cent of the total salary or cost-to-company (CTC). At the moment, most companies give employees a lower percentage of basic pay while keeping the number of allowances higher. However, this will change as soon as the new wage code comes into effect. Some reports indicate that the new wage code will come into effect from April, but the government has not officially declared it till now. Last month, it was informed that the government is working to notify it soon. WHAT HAPPENS TO YOUR SALARY? When the new wage code kicks in, employers have to pay at least 50 ...

Step to Create a Basic Macro : 1)open up a new book, bring up the Developer tab (If you don't have the Developer tab, you can go to File, Options, Customize Ribbon and makes sure that the Developer tab is selected.) 2)open VBE editor (Developer -> Visual Basic or ShortcutKey: ALT+F11) 3)Add Module (Insert -> Module, Module is nothing but a workspace to writer our code) 4)Write/copy below code in Module workspace and click on RUN(F5)/PLAY option Sub MyFirstMacro() MsgBox "Welcome to MYTECHIE EXPERT BLOG" End Sub 5)You'll get "Welcome to MYTECHIE EXPERT BLOG" output in message box

Macro : What is meant by Macro : It is an excel/vba programming set of statements to perform specific task on a single button click Why we need a Macro : Let’s consider a Scenario • In My Project, to do some activities such as Database cache clean activity, verify patch logs, check application behaviour on daily basis before getting into my work. Just imagine, if all such activities handled daily by just a single BUTTON CLICK. Yeah this is possible with EXCEL MACRO programming Where to use a Macro : If any repetitive daily activity, you can use EXCEL MACRO in place of it with little bit programming.

It's really important that whenever you make something in the VBE(Called Visual Basic Editor), whenever you insert a module and you put code in there, you have to make sure that you're saving your workbook as not just a regular XLS exe file , but XLS EM .So, it's called the Macro Enabled Workbook. How can you do that , 1)Open Excel, Go into File 2)Select Save As option 3)And for the file type, you can choose here instead of Excel workbook, you can choose Excel Macro-Enabled Workbook.Again. Take a Note Of : If you've any sort of macros or you write code in a sub or a function, it has to be a Macro-Enabled Workbook, if you just save it as an Excel workbook, it's going to lose all of those modules and the code that you put in there.