How to create/record a Macro

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

Comments

Difference Between Programming and Coding

What exactly is the difference between programming and coding? The other day, one of my friends who is not from a computer science background, asked me this question. Even after learning many different programming languages and doing several projects, I could not answer him correctly. I said both are the same. But why do we use two different terms, if both are the same? That led me to some research, and I thought I’d share what I found. It’s not that complicated. And their definitions allow for a lot of overlap. We often recognize the terms coding and programming as synonymous because both are often used interchangeably. what is the difference between programming and coding? Coding is the act of expressing programmatic ideas in computer language. Programming is crafting ideas that can be executed repeatedly by a machine, not necessarily a computing device. While both the terms are synonymous with each other and are often used interchangeably, t...

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...

Variables, Data Types and Math Operations

In order to do anything interesting in a program, we must have the ability to store and manipulate values. What allows us to do that are what we call variables. Now a variable, simply put, is just named data storage. Now Java is a strongly ‑ typed language. Now what that means is that when we declare a variable like, in this case, we have a variable named data Value, we have to specify the type of that variable, in this case, it's what we call an int, something that can store integers. So, what that means is that the data Value variable can only store things that are compatible with the type int. As we go through the course, we'll talk about this idea of one type being compatible with another. Now when we declare a variable, we can, of course, then assign a value to it, so our variable data Value now holds the value 100. Now when we use variables, we can do it the way we've done here where we declare it, then assign it, or as a matter of convenience, we can declare them a...

The Study Secretz

Search This Blog