Macro - What, Why, Where

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.

Comments

RPA Implementation Approach

RPA Implementation Approach: 1. Tool Selection o Based on user requirements, features available in tools, you’ve to select TOOL from mentioned above 2. Process Prioritization o After successful section of Tool, you’ve to consolidate & prioritize the all processes in current operation. Let’s start automating lowest first and most important to next

Brief Overview of RPA

Brief Overview of RPA: § In short, it’s a way for machines to replace human workers in regular activities done across the organization. § It works on both Front End & Back End applications/operations. § BOT provides Virtual automation agents , it acts like MIMIC HUMANS . § BOT ’s available in Clouds/Servers § BOT is nothing but a configurable software set up, works only on rule-based triggers § It automates Non-Value –added works § It is a Sub Domain of BPMS (Business Process Management Software)

Why RPA, Why not Other Tools

Like below there are several features compared to other tools RPA QTP/UFT SELENIUM Commercial Commercial Open Source Less Programming Moderate Programming More Programming License Cost is Less License Cost is More No license cost Free Version No/Minimal additional cost for extra bots Add-Ins Additional cost is very high Free/Paid Add-Ins are available ROI is more ROI is less compare to RPA ROI is more as Open Source Error rate almost to Zero Error rate is moderate Error rate is moderate Customer Satisfaction is high Customer Satisfaction is Moderate Customer Satisfaction is Moderate User Friendly User Friendly Complex 24*7 support 24*7 support No Support

The Study Secretz

Search This Blog