Skip to main content

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

Post a Comment

We appreciate your valuable Suggestions/Feedback

Popular posts from this blog

Key Points of Leading RPA Tools

Key Points of Leading RPA Tools Automation Anywhere(AA) Blue Prism(BP) UI Path Developer friendly tool RPA Term was invented by Blue Prism Extremely User Friendly Offers Front and Back Office Robots It is an Enterprise grade RPA Solution tool Implementation Speed is high Script based, More Programming Skills required Supports only Back Office robots Re Usability is more since various integrations available with different workflows Smart Recorder Option available Code Insertion is difficult and not user friendly Free Community edition (PDF’s, Videos available for FREE) AA Bots can deploy in Physical Front Office machines & Cloud Extreme control over activities (Object Creation, Coding etc.) Con is - No Coding Annual support cost and license cost is higher What is Best RPA Tool...
4 comments
Read more

Types of Recording

Types of Recording: 4 types of recording modes are available Ø   Basic Ø   Desktop Ø   Web Ø   Citrix 2 ways of Recording Ø   Automatic Ø   Manual Basic – generates a full selector for each activity and no container, the resulted automation is slower than one that uses containers and is suitable for single activities. Desktop – suitable for all types of desktop apps and multiple actions; it is faster than the Basic recorder, and generates a container (with the selector of the top-level window) in which activities are enclosed, and partial selectors for each activity. Web – designed for recording in web apps and browsers (supported: Internet Explorer, Google Chrome), generates containers and uses the Simulate Type/Click input method by default. Citrix – used to record virtualized environments (VNC, virtual machines, Citrix, etc.) or SAP, permits only image, text and keyboard automation, and requires explici...
Post a Comment
Read more

HELLO WORLD

As of now, you've learned some basics of RPA & UI Studio . Now, It's a time to create your first program (Obviously " HELLO WORLD ") in UI Studio as below. Creating a New Sample Project : Here I’m displaying HELLO WORLD along with User Input with Flow Chart workflow 1)        Open UI Path studio 2)        On the Start tab, under the New section, click Blank . The New Project window is displayed. 3)        Enter NAME for the Project (say HELLOWORLD) & Select Project Location and Click on CREATE button. New Project (Main.xaml) is created in Chosen Location. 4)        Add/Drag and Drop any workflow/activity (like Flowchart) from Activities Panel 5)        Add Input Dialog activity 6)        Connect Input Dialog activity to Start node by selecting ‘Se...
1 comment
Read more