Nobody downloaded yet

Automation Tools - Essay Example

Comments (0) Cite this document
Summary
1. (a) It is possible to create fully functional macros by using the view however one needs to resort to using using the Visual Basic Editor to do dmanual coding. This is primarily when your conditions to perform a certain set of activities changes depending on various conditions…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.4% of users find it useful
Automation Tools
Read TextPreview

Extract of sample "Automation Tools"

Download file to see previous pages However your data might change making your recorded macro unusable. Using a Do - Loop Until function will solve your problem as you are now able to instruct the macro how many times a particular set of instructions need to be completed.
Using Variables - You are not able to use a variable to store data using the record macro function. You will have to resort to use the VB editor once again. Apart from the fact that you are able to store information in these variables, a fuction called Evaluate in VBA will let you use MS Excel commands like concatenate etc within VBA. You need not use Excel to do calculations. Even referencing conplicated fuctions such as DSUM varies according to your data.
Using properties of a Cell selection - Lets say you need the cell address of every cell containing the word "Penguin" and have that on a separate sheet. Record Macro will not be able to give you the solution whatsoever. Using VB Editor, you can use the Cell.Find function to search for the word "Penguin" along with the selection.address function and enter the cell address into a variable. A message box can then be called using the Msgbox fuction to display the value stored in the variable. This example contains three different offings (variable, Selection.Address and Msgbox) which the record macro function is unable to offer.
1.(b) The are many ways of accessing the library. ...
Others are by clicking the object library button on the toolbar or by clicking the Object Browser button in the view menu.
The information provided by the library is quite large and in depth. It will provide the below information:

Various Classes available
Objects member available in a particular class
The type of the object (Function, Property etc)
The argument a function accepts along with the type of arguments
Also the value type returned (Range, Long etc)

As an example, if you search for "Offset" in the search box, you will find the following information in the display area:

Property Offset([RowOffset], [ColumnOffset]) As Range
read-only
Member of Excel.Range
This means that the function "Offset" is member of Class Range and Library Excel.
The function accepts arguments in the form of the row number followed by column number and will treat it as a range. It is read only which means it can be used only to retrieve information but to enter any into the cell.

1.(c) VBA offers a number of debugging facilities. These are:

Jump over: VBA will overlook a piece of code which has a single quotation mark in front of it. This way you can skip a particular line of code that you find to be causing an error.

Run and Wait: VBA will allow you to select a line of coding by clicking the margin in front of it and highlighting it in red. It will run all the commands before the highlighted one and wait for you to check the highlighted one. You can then hover your mouse pointer over the highlighted code and the value of the result will be displayed. This is very useful while using variable.
This method can be used for an entire selection of codes.

1.(d)
Function mean(rng As Range) As Double

Dim freq, total As Integer
Dim r As ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Automation Tools Essay Example | Topics and Well Written Essays - 1500 words”, n.d.)
Automation Tools Essay Example | Topics and Well Written Essays - 1500 words. Retrieved from https://studentshare.org/miscellaneous/1525212-automation-tools
(Automation Tools Essay Example | Topics and Well Written Essays - 1500 Words)
Automation Tools Essay Example | Topics and Well Written Essays - 1500 Words. https://studentshare.org/miscellaneous/1525212-automation-tools.
“Automation Tools Essay Example | Topics and Well Written Essays - 1500 Words”, n.d. https://studentshare.org/miscellaneous/1525212-automation-tools.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Automation Tools

Researching reporting dashboard features for marketing automation tools

... Researching Reporting Dashboard Features for Marketing Automation Tools Executive Summary Working with Microsoft Access, Excel, or similar software, logical programming and design, are integral for the creation of useful reports from raw data. It is essential to determine the data, how it is to be organized, and the way it should be displayed in final reports. These exercises are intense and could leave some people frustrated. For those who are technologically challenged, various Business Intelligence firms have developed cutting edge technology and are marketing it to enable regular business users to create visually stimulating and interactive reports through dashboards (Wolenik et al 11). These dashboards are the antithesis... or...
4 Pages(1000 words)Research Paper

Feedback Control and Automation

...Running Head: FEEDBACK Feedback Control and Automation Question Research at least two methods of design compensators, which are used to cause a practical unstable system to run as a stable system under the desired operating frequency range. Write a comparison of relative merits of each type. Answer: Although the prime objective of a control system is to have optimum performance yet without any adjustment it is rare indeed. Usually we have to compromise among many conflicting and damaging specifications and have to adjust the system parameters to achieve a suitable performance although it is not possible to obtain all desired optimum specifications. The control system adjustment or stabilization and...
6 Pages(1500 words)Research Paper

Sales Force Automation

...Sales Force Automation Introduction: In a continuously changing business environment it has become challenge for businesses to train and equip their sales staff according to the changing needs. In order to respond to these challenges the marketing gurus have implemented many techniques & tools in order to keep up the pace with the volatile nature of business. A sales force automation program is one of the tools being implemented all over the world in companies who want to have cutting edge in their business. In order to under stand wholly the benefits of the sales force automation, it is important to understand what sales force automation actually is. As explained at trai.org “Sales force automation refers to automating all... the...
8 Pages(2000 words)Essay

Horizon Automation System

...communication & access of remote database with MARC21 (US-MARC default) format for cataloging information. The Z39.50 client must be running at the Library local system. Communication between the client and the server is via a Z39.50-Association (Z-Association). There may be multiple Z-associations for a connection and multiple consecutive as well as concurrent operations within a Z-association. Horizon Automation System The Horizon Integrated Automation System is a library management system marketed by SirsiDynix (formerly Ameritech library services a subsidiary of Ameritech Corporation). The important features of this library system are: 1. Cataloguing - The tools for search & display...
6 Pages(1500 words)Essay

Automation Tools Math Problem

...the workbook, containing this code fragment, is opened. Private Sub Workbook_Open() ThisWorkbook.ActiveSheet.UsedRange.Select End Sub Output: 3. The below code snippet creates a list of numbers (1 to 5) in Sheet1, whenever the workbook, containing this code fragment, is opened. Private Sub Workbook_Open() For counter = 1 To 5 ThisWorkbook.Sheets("Sheet1").Cells(counter, 1).Value = counter Next counter End Sub Output: Question 1(b): VBA is supported by an extensive library of classes. Describe how this library is accessed and what information relating to the various classes is provided. Answer 1(b): To view the list of classes available for VBA, open an excel workbook and go to...
11 Pages(2750 words)Math Problem

Automation Systems

.... As a result, the specialists often took a lot of time to understand the processing requirements of a new department. This problem has a great impact to the new users as it caused delays in a project and sometimes led to misunderstanding - in other words, some of the new automated system developed failed to meet the needs of the department, or failed to meet them on time. To prevent this problem, the developer must develop a user friendly automated system. Although, most employers expect their potential employees to be prepared to use computers as tools whatever field or business. In response, automation system will be very helpful to firms. They felt they needed some...
8 Pages(2000 words)Essay

Accuracy and Automation

...The program to improve child’s numerical ability specifically subtraction of numbers up to 100 requires knowledge of counting and addition to enable the child to imagine the process of subtraction which is considered as the reverse process of addition. Given that the child is already able to do addition of integers from 1 to 100, the child is ready to be introduced to the process of subtraction. It is necessary to check if the child knows how to count backwards such as counting from 10 to 1. Aside from this, the terminologies used for subtraction should be introduced to the child including the symbols and the meaning of these symbols to the process of subtraction. First, subtraction of one digit numbers without the need... program to...
2 Pages(500 words)Essay

Automation Assembly Parts

... from being a tool for product and process design to being used for strategic planning systematically linking customer requirements with organisational functions and processes. A study has been proposed to review QFD practices and develop a mechanism for implementing QFD. The objective of the study is to review available literature on QFD, and develop a methodology for QFD implementation within an organisation. Published literature in journals, conferences, and case studies would be considered for the study. The development of a product includes several processes, and QFD enables an analysis of every process for satisfying customer requirements within the functional constraints of the organisation. The scope of this study is QFD... in a...
32 Pages(8000 words)Essay

Job Automation

...Automation in Healthcare Automation in Healthcare The Healthcare field is notorious for its slow and late adoption of potentially labor-saving and cost-saving technology. However, one cannot deny the fact that the healthcare field too is changing considerably as a result of technology. According to the HealthLeaders Media Industry Survey 2012, labor costs are one of the most important cost drivers in the industry. The stunning revelation is that nearly 50-60% of the total expenses are incurred in the form of salaries and benefits. The benefits of automation are rather obvious from the figures. Betbeze, in an article named Automation and the healthcare cost curve dated...
2 Pages(500 words)Essay

The impact of automation

...Impact of Automation Impact of Automation Automation involves the use systems that are controlled by computers in the manipulation or direction of industrial processes and machinery in place of human operators. With automation, human use in industries and other places of work reduces affecting human life in different ways. Automation has impacted differently on certain facets of the society owing to the different changes that has been facilitated by automation. This study provides a deep description of the impact of automation on the global, society, and the economy. Automation impact on society The main...
5 Pages(1250 words)Term Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Automation Tools for FREE!

Contact Us