Saving your files as macro-enabled workbooks

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.

Comments

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

Variable

Variable Ø Variable is nothing but a memory location Ø It holds multiple types of data Ø Data stored in Variable is named as ‘Value’ Ø Supports a large amount of types, ranging from generic value, text, number, data table, time and date, UI Elements to any .Net variable type. Create a Variable: On the Design ribbon tab, in the Variables group, select Create Variable > [Type of variable] . The Create Variable window is displayed Fill in the required fields and click OK . The variable is created and you can view and edit it in the Variables panel. 1.In the Properties panel of any activity, right-click a field that can be edited, and select Create Variable from the context menu, or press Ctrl+K....

The Study Secretz

Search This Blog