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
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...
Comments
Post a Comment
We appreciate your valuable Suggestions/Feedback