Preview

macros

Good Essays
Open Document
Open Document
1080 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
macros
Macros are commands that symbolizes a sequence of instructions in an abbreviated form. Those instructions consist of a symbol, a name, or a key that represents a list of commands, actions, or keystrokes. A macro is a shortcut to for a task that you do repeatedly (Microsoft Word Macros). In programs like, Microsoft words, Microsoft Excel, and other programs, a macro is a saved sequence of commands or keyboard strokes that can be stored and then recalled again with a single command or keyboard stroke. In computers, a macro is any programming or user interface that when used, it expands into something larger. The original use for a macro or ‘macro definition’ was in computer assembler language before higher level, easier to code languages became more common. Microsoft Office documents, such as Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and other types of documents can contain embedded code written in a programming language known as Visual Basic for Applications (VBA). A macro is also a set of computer instructions that you can use to record and associate with a shortcut key combination or a macro name (Microsoft). When you press the shortcut key combination or click the macro name, your computer program automatically responds by carrying out the instructions of the macro. In return, this process saves you time by replacing a repeatedly used, and sometimes lengthy series of actions with a shorter action (Microsoft). The typical uses for a macro are: to speed up routine editing and formatting, to combine multiple commands like, to insert a table with a specific size and a borders specific number of rows and columns, to make an option in a dialog box more accessible, and to automate a complex series of task. You can choose to either record a sequence of actions, or you can write a macro from scratch by entering it in Visual Basic for Applications (VBA) code in the Visual Basic Editor (VBE). A In a way, macros are like simple programs or batch

You May Also Find These Documents Helpful

  • Satisfactory Essays

    BIS115_Quizzes

    • 2722 Words
    • 11 Pages

    Enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle…

    • 2722 Words
    • 11 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Capsim Study Guide

    • 17212 Words
    • 69 Pages

    1. When opening the Excel version of Capstone®, you should do what to Macros? a. Enable b. Disable c. Engage d. Disarm e. Does not matter…

    • 17212 Words
    • 69 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 42 M3

    • 430 Words
    • 2 Pages

    As we did this task already you can explain how you recorded the macro and how it can be useful for the user, such as repetition of tasks, saving time etc.…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Even though Macros do it yourself software is ranked as one of Microsoft’s most useful tools to use. Based on the article by Lenning (2005) the primary security risk for users to know using macros is that many of these sites could have many different types of viruses. It is recommended that one should use caution when opening a new document. You should only open and used a trusted because some files can be corrupted and then they will spread viruses to your computer and most of the time you do not know where they come from. Depending on which version that you are going to use you will get a warning every time for a file that contains a macro. This is done because many times macros can be programmed to act like a virus. Before even considering opening a marcro site one has to remember that it can be dangerous to their computer. Because these viruses that pretend to be a marco they can get into your computer and delete files and cause other damage to your system as viruses are meant to do. It’s a good idea to be careful when you enable macros. There are a couple of ways to help keep your computer safe; I would look at installing the lasts service packs and updates for Microsoft. I would also make sure I had a strong firewall/anti- virus program on my computer. But, the main way to help keep your computer safe I feel is to pay attention to what you are using, what sites, and what you…

    • 275 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Unit 9 Alvarez

    • 726 Words
    • 3 Pages

    MICROSOFT OFFICE ONLINE. (2014). Work with Macros. Retrieved January 20, 2015, from Office online: http://office.microsoft/com/en-us/excel-…

    • 726 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Excel Chapter 1

    • 4708 Words
    • 19 Pages

    B) the current cell location of the insertion point as indicated by a dark border.…

    • 4708 Words
    • 19 Pages
    Satisfactory Essays
  • Satisfactory Essays

    understanding macros

    • 668 Words
    • 6 Pages

    Complete the following tasks by using the Microsoft® Word® document located on the student website:…

    • 668 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    Itq Coursework

    • 6612 Words
    • 27 Pages

    In some programmes like microsoft office you can automate frequently used tasks by creating macros. A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. Macros are used to speed up routine editing and formatting, to combine multiple commands, to make an option in a dialog box more accessible, to automate a complex series of tasks.…

    • 6612 Words
    • 27 Pages
    Good Essays
  • Good Essays

    Microsoft Excel is an electronic spreadsheet program which is used to store, organize, and handle data. It is a grid that consists of rows which consists of numbers, columns which consists of letters, and cells which is the unit that is used to store data. It can also be used for graphing, sorting, and filtering data. (About.com Spreadsheets, 2012)…

    • 828 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Microsoft Word has many capabilities that can help in many aspects of work and personal life. The recent versions allow you to create almost everything from invitations to projects and papers for school. Understanding shortcuts and how to properly use them, can save you time and help you work more efficiently.…

    • 576 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    To apply the stored-program concept, central processing unit (CPUs) are designed to recognize instructions encoded as bit patterns. This collection of instructions along with the encoding system is called the machine language. An instruction expressed in this language is called a machine-level instruction or, more commonly, a machine instruction.…

    • 458 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Copyright © 2012 Pearson Education, Inc. 0-5 Terminology • Machine instruction: An instruction (or command) encoded as a bit pattern d) d d tt recognizable by the CPU • Machine language: The set of all instructions recognized by a machine Copyright © 2012 Pearson Education, Inc. 0-6 3 Machine Language Philosophies • Reduced Instruction Set Computing (RISC) – Few, simple, efficient, and fast instructions – Examples: PowerPC from Apple/IBM/Motorola and ARM • Complex Instruction Set Computing (CISC) –…

    • 783 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Speed – A computer can search through files and records quickly to find the information you require. It can also make it quicker and easier to change a mistake.…

    • 1465 Words
    • 6 Pages
    Powerful Essays
  • Better Essays

    Macro Systems

    • 1227 Words
    • 4 Pages

    micro, and mezzo. It will also discuss the macro system response to child maltreatment, sexual…

    • 1227 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Macro: Mezzo Social Work

    • 340 Words
    • 2 Pages

    On the macro Social Work level the worker will be working with larger groups and larger organizations. A macro practice would be working to make new laws or change the current laws that slow the growth of the client population. If you decide to work in social services or are currently working in social services you will find yourself working the macro, micro and mezzo social work level.…

    • 340 Words
    • 2 Pages
    Satisfactory Essays