Nt1330 Unit 3 Assignment 1 Data Analysis

Good Essays
Open the excel file which is password protected and goto Macro's (I am using Office 2007 so the menu's maybe different View >> Macros). Click on "Record Macro >> OK" and then click on "Stop Recording" from the same menu. Now goto "View Macros", you will find a Macro with a default name E.g. Macro1 - Select the macro name and click on Edit. Now a Visual Basic Editor opens up. Re-place the default code and Paste the below code.

Sub Macro1()
'
' Breaks worksheet and workbook structure passwords. Jason S

' probably originator of base code algorithm modified for coverage

' of workbook structure / windows passwords and for multiple passwords

' Jason S http://jsbi.blogspot.com

' Reveals hashed passwords NOT original passwords

Const DBLSPACE As String = vbNewLine & vbNewLine
…show more content…
Const AUTHORS As String = DBLSPACE & vbNewLine & "Adapted from Bob McCormick base code by" & "Jason S http://jsbi.blogspot.com"

Const HEADER As String = "AllInternalPasswords User Message"

Const VERSION As String = DBLSPACE & "Version 1.0 8 Sep 2008"

Const REPBACK As String = DBLSPACE & "Please report failure to jasonblr@gmail.com "

Const ALLCLEAR As String = DBLSPACE & "The workbook should be cleared"

Const MSGNOPWORDS1 As String = "There were no passwords on " & AUTHORS & VERSION

Const MSGNOPWORDS2 As String = "There was no protection to " & "workbook structure or windows." & DBLSPACE

Const MSGTAKETIME As String = "After pressing OK button this " & "will take some time." & DBLSPACE & "Amount of time " & "depends on how many different passwords, the "

Const MSGPWORDFOUND1 As String = "You had a Worksheet " & "Structure or Windows Password set." & DBLSPACE & "The password found was: " & DBLSPACE & "$$" & DBLSPACE & "Note it down for potential future use in other workbooks by " & "the same person who set this password." & DBLSPACE & "Now to check and clear other passwords." & AUTHORS &

You May Also Find These Documents Helpful

  • Satisfactory Essays

    NT1310 Unit 2 assignment

    • 475 Words
    • 2 Pages

    RBOCS- Regional Bell operating company (RBOC) is a term describing one of the U.S. regional telephone companies (or their successors) that were created as a result of the breakup of American Telephone and Telegraph Company (AT&T, known also as the Bell System or "Ma Bell") by a U.S. Federal Court consent decree on December 31, 1983. The seven original regional Bell operating companies were Ameritech, Bell Atlantic, BellSouth, NYNEX, Pacific Bell, Southwestern Bell, and US WEST. Each of these companies owned at least two Bell operating companies (Bell operating company). The BOCs were given the right to provide local phone service while AT&T was allowed to retain its long-distance service.…

    • 475 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Nt1310 Unit 2 Assignment

    • 500 Words
    • 2 Pages

    The grade level of my students for this discussion is 6th grade and I will be teaching world cultures.…

    • 500 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Nt1330 Unit 1 Assignment

    • 2207 Words
    • 9 Pages

    This paper gives an idea regarding the important aspects of the database security. It mainly focuses on the security parameters such as confidentiality, authenticity and availability of the data. It also explains the different threats for the security in an organization in relation to the database. The basic steps which are required to control the loss of data are explained in detail. Among the controls the encryption process is the one which has to be followed to control the access into an…

    • 2207 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Nt1330 Unit 2 Assignment

    • 1384 Words
    • 6 Pages

    Penalty: You must provide all of the information requested by the HA, including all Social Security Numbers you,…

    • 1384 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Nt1310 Unit 1 Assignment

    • 579 Words
    • 3 Pages

    1. Cancer is a group of diseases in which cells grows and divide out of control, it is caused by a change in DNA that controls the cell cycle. This DNA change causes for cells not to stay in interphase for the normal amount of time, and some of the checkpoints fail and cause the cells to divide uncontrollably. The uncontrollable division rate can create a massive group of cells called a tumour. The cells of the tumour may stay together and have no other effect on the tissues around it, this is known as a benign tumour. There is also a tumour known as a malignant tumour, which causes interference with functioning of neighbouring cells and tissues. Malignant tumours could even destroy surrounding tissues, but malignant…

    • 579 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Nt1310 Unit 2 Assignment

    • 1160 Words
    • 5 Pages

    Genetically modified crops are plants used in agriculture in which the DNA has been modified using genetic engineering techniques. In other words, genetically modified organisms have specific changes in their genetic information, by the process of introducing foreign genes into the cells. Genetically Modified Crops have had a gene extracted from a living thing placed into a different food by a scientist. This technology can be used to produce new varieties of plants more quickly than conventional breeding methods. Genetically Modified Crops are created for many different reasons. The two main types of GM crops that are in commercial use around the world are either crops…

    • 1160 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Nt1310 Unit 2 Assignment

    • 3487 Words
    • 14 Pages

    1. Most current studies aimed at understanding human memory are conducted within a framework known as information-processing theory. This approach makes use of modern computer science and related fields to provide models that help psychologists understand the processes involved in memory. The general principles of the information processing approach to memory include the notion that memory involves three distinct processes. The first process, encoding, is the process of transforming information into a form that can be stored in memory. The second process, storage, is the process of keeping or maintaining information in memory. The final process, retrieval, is the process of bringing to mind information…

    • 3487 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    Nt1310 Unit 2 Assignment

    • 506 Words
    • 3 Pages

    An example is of a virtual insurance company, we're not talking only aboutInternet delivery for products. We're talking about the online insurance agency necessarily, although that's certainly one component of the enterprise. We're also talking about back-office infrastructure and support, perhaps dedicating third parties to support this infrastructure to create an electronic communications medium.…

    • 506 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Nt1310 Unit 2 Assignment

    • 817 Words
    • 4 Pages

    This paragraph should contain five sentences only. Write about your culture, something about your family generation before your parent's generation, how are you connected to the generation prior to your parent's generation, tell us about your parents and siblings, your community when growing up and your current community, and something about yourself. All paragraphs with over five sentences will receive a minus five points per extra sentence. Please only five sentences.…

    • 817 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Nt1330 Unit 5 Assignment

    • 2359 Words
    • 10 Pages

    Table of Contents 1 Introduction 2 2 Overview 2 3 Static Data File 2 4 Request & Response 2 4.1 Request 2 4.2 Response 3 5 Operations 3 5.1 Region List (rtype=1) 4 5.2 Region List (rtype=2) 4 5.3 Hotel Details (rtype=3) 5 5.4 Keyword Search (rtype=4) 6 5.5 Region Search (rtype=5) 7 5.6 Geo Search (rtype=6) 8 5.7 Availability and Rates (rtype=7) 8 5.8 Special Offers List (rtype=8) 9 5.9 Special Offers (rtype=9) 9…

    • 2359 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Nt1330 Unit 3 Assignment

    • 2805 Words
    • 12 Pages

    No one knows exactly when Yoga began, but it certainly predates written history. Stone carvings depicting figures in Yoga positions have been found in archeological sites in the Indus Valley dating back 5,000 years or more…

    • 2805 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Nt1310 Unit 2 Part 2

    • 983 Words
    • 4 Pages

    TMA 01 – With the help of examples from the surveillance film, outline the ways in which surveillance is used to deliver crime control and social welfare (600-800 words).…

    • 983 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Nt1330 Unit 2 Assignment

    • 425 Words
    • 2 Pages

    1. Read “featured Teacher" and explain how learning from this teacher will reflect in your behavior with students with special needs.…

    • 425 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    This year you were able to average 95.05% on CSAT. The department goal is 96%. Based on your score, you partially met the department goal in CSAT. Your rework for the year was 6.48 %. Based on the department goal and the department average, you are exceeding expectations in rework. Your Net Promoter Score is 66.22 % for the year. This percentage is within the department range. This year you averaged 8.85 points per hour. the department goal for the year is 10 points per hour. Based on the department goal and the department average You landed right within the meeting expectations. your whole house in range averaged 95.78%. This percentage landed right within the department goal and the department range. Your whole house completed was 92.57 percent.…

    • 276 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Nt1310 Unit 3 Assignment

    • 629 Words
    • 3 Pages

    In a bus configuration, each computer in the network is responsible for carrying out its own communications without the help of a central unit. A common communications cable (the bus) connects all of the computers in the network. As data travels along the cable, each unit performs a query to determine if it is the intended recipient of the message. The bus network is less expensive than the star configuration and is thus widely in use for systems that connect only a few microcomputers and systems that do not emphasize the sharing of common resources.…

    • 629 Words
    • 3 Pages
    Satisfactory Essays