Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
Program in VBA (Visual Basic for Applications) - cover

Program in VBA (Visual Basic for Applications)

Olga Maria Stefania Cucaro

Publisher: ResearchFreelance

  • 0
  • 0
  • 0

Summary

This work was born from the necessity found by the author to solve problems of various kinds during her studies and work. The large amount of data and the repetitive processing required an automated procedure that could be applied in any context. The author, being a programmer and being an expert in Pascal, Cobol and Javascript, searched for the most suitable solution and found it in the Excel VBA. This document is intended to introduce users to programming in general and to programming in Visual Basic for Applications and Excel in particular. VBA is simple and can be used on existing Excel files, quickly processing a large amount of data. The only tool we need is Excel.
The book may not contain everything you should know about programming in VBA, but it does point the finger at the key points to create some programs which are explained in the various chapters. The content is divided into two parts one which explains programming in general and the second which explains programming in VBA with concrete examples of programs. In this latest version, more complex electronic procedures have been added that process various Excel files at the same time that can be used for warehouse management, for the management of work orders, for the management of payrolls and in all those problems where it is necessary. create summary reports of input data in different files. Obviously we will not write all the possible examples because they are infinite,
 
Available since: 07/31/2021.
Print length: 156 pages.

Other books that might interest you

  • Touchpad iPrime Ver 11 Class 4 - cover

    Touchpad iPrime Ver 11 Class 4

    Team Orange

    • 0
    • 0
    • 0
    Computer Science Textbook Designed for Joyful Learning 
    
    KEY FEATURES 
    - National Education Policy 2020 
    - Tech Funda: This section provides a practical information or tip to the students. 
    - Clickipedia: This section provides interesting computer facts. 
    - Hands-On: This section contains an activity for Home assignment. 
    - QR Code: Scan the QR Code given on the first page of each chapter to start chapter animation. 
    - Crack the Code: This section has puzzle or fun based activity to help understand the concepts better. 
    - Digital Resources 
    
    DESCRIPTION 
    Touchpad iPRIME (Ver 1.1) series based on Windows 7 & MS Office 2010 is comprehensively designed as per the new ICSE syllabus. Learning is done best when it’s fun-filled and activity based. To ensure that the content intrigues the students at all times and keeps them interested throughout the course of the book, we have included interesting key features like Student Corner, Tech Funda, Clickipedia, Comp Caution, Reboot, One Touch Learn, Let’s Do It, Crack The Code, Hands-On, Fun In Lab, Teacher’s Corner, Worksheet, Test Sheet, Project, Speech Drill, Supplement Pages and Glossary. 
    
    WHAT WILL YOU LEARN 
    You will learn about: 
    - Fundamentals of computers 
    - ICT Tools 
    - Computational Thinking 
    - Storage and Memory Devices 
    - Word 2010 Editing 
    - Internet 
    - MS PowerPoint 2010 
    - Stepwise Thinking 
    - File Management 
    
    WHO THIS BOOK IS FOR 
    Grade - 4 
    
    TABLE OF CONTENTS 
    1. Computers—Storage and Memory Device 
    2. GUI Operating System—Desktop Management 
    3. Editing in MS Word 2010 
    4. Formatting in MS Word 2010 
    5. The Internet–Web Browser 
    6. Introduction to MS PowerPoint 2010 
    7. Stepwise Thinking 
    8. Features of File Management 
    9. Project Work 
    10. Explore More (Windows 10) 
    11. OGO Cyber Sample Questions 
    12. Glossary
    Show book
  • Heartwarming - How Our Inner Thermostat Made Us Human - cover

    Heartwarming - How Our Inner...

    Hans Rocha Ijzerman

    • 0
    • 0
    • 0
    A hot cup of tea, coffee, or cocoa is calming and comforting—but how can holding a warm mug affect our emotions? In Heartwarming, social psychologist Hans Rocha IJzerman explores temperature through the long lens of evolution.Temperature contributed to our evolution—our upright walking, our loss of fur, and our big brains—and now continues to affect our lives in unexpected ways, and the link from a warm mug to our emotions is anything but straightforward. Studies have shown, for example, that a chilly deliberation room can predispose a jury to convict and that a cold day can make us more likely to buy a house. Our mind-body connection works the other way, too: thinking about friendly or caring people can make us feel warmer. Understanding how we subconsciously strive to keep our temperature in an optimal range can help us in our relationships, jobs, and even in the world of social media.As IJzerman illuminates how temperature affects human sociality, he examines fascinating new questions: How will climate change impact society? Why are some people chronically cold, and others overheated? Can thermoregulation keep relationships closer, even across a distance? The answers offer new insights for all of us who want to better understand our bodies, our minds, and each other.
    Show book
  • Drone Warfare - The Development of Unmanned Aerial Conflict - cover

    Drone Warfare - The Development...

    Dave Sloggett

    • 0
    • 0
    • 0
    The Development of Unmanned Aerial Conflict will examine the development and use of aerial drones, a topical subject that has not been written on to date.An unmanned aerial vehicle, commonly known as a drone, is an aircraft without a human pilot on board. Its flight is either controlled autonomously by computers in the vehicle, or under the remote control of a navigator or pilot on the ground or in another vehicle.Blending history with current and recent operations, Dr Sloggett will set out to put the record straight. In some quarters of the press drones get a bad press and there has been much controversy over their deployment, some of which is not deserved.The book reveals the history of unmanned aircraft, their recent development and why they have emerged onto the scene. Why did the US, for example, really invest highly in drone technology? When did all that start? What barriers had to be overcome? What was there before drones arrived?The book also analyses their operations in Iraq in Gulf War Two and more recently Afghanistan. What roles did drones play? Where they successful? What new developments emerged during operations? Did they save lives? Further to this is a detailed look at case studies where they have been used trying to remove some of the incorrect reporting – putting the record straight based on evidence. How many have been shot down and where?The book then looks at strategic uses of drones at present: Iran is being monitored; they are already in action over parts of Africa; what are other countries doing – China, Iran? Turkey?The RAF's use of drones, their deployment and operations is considered along with important questions such as where this goes for the future. What are the issues? Will all air forces be drone based in the future? What other applications may arise in the civilian market?
    Show book
  • Hope Not Nope - cover

    Hope Not Nope

    Dillon Caswell

    • 0
    • 0
    • 0
    “Hope Not Nope reveals the timeless prescription for vitality and well-being.” ~Featured on: NBC, ABC, CBS, FOX 
    Hope Not Nope powerfully moves you towards a more positive existence by equipping you with the tools to update your mindset and become a modern-day champion. In the title and writing the term “Lifelong Athlete” is utilized to imply hope is cultivated in this identity, but also adds a fresh perspective: Hope is not wishful thinking, it’s learned and earned. The “Lifelong Athlete” identity is not just related to competitive events, it’s living out the values of servant-based leadership to achieve wholeness: Health. 
    “It is rare to hold such a comprehensive, point, and powerful compilation of all that is positive in my hands. I have to go back to The Power Of Positive Thinking, written by Dr. Norman Vincent Peale in 1952, to find its equal." ~Tim Green, NY Times Best Selling Author, Former Atlanta Falcons Star Defensive End 
    If your goal is to achieve the desires placed on your heart, make each day better than the last, and leave a lasting legacy for the next generation to follow, then the simple not easy solutions presented in this “wellness and longevity roadmap” will be not only your inspiration but your guide.
    Show book
  • Math-ish - Finding Creativity Diversity and Meaning in Mathematics - cover

    Math-ish - Finding Creativity...

    Jo Boaler

    • 0
    • 0
    • 0
    From the Stanford professor—an expert in the field of mathematics education—and author of Limitless Mind, a groundbreaking guide to finding joy and understanding by adopting a diverse approach to learning math.  
    Mathematics is a fundamental part of life, yet every one of us has a unique relationship with learning and understanding the subject. Working with numbers may inspire confidence in our abilities or provoke anxiety and trepidation. Stanford researcher, mathematics education professor, and the leading expert on math learning Dr. Jo Boaler argues that our differences are the key to unlocking our greatest mathematics potential. 
    In Math-ish, Boaler shares new neuroscientific research on how embracing the concept of “math-ish”—a theory of mathematics as it exists in the real world—changes the way we think about mathematics, data, and ourselves. When we can see the value of diversity among people and multi-faceted approaches to learning math, we are free to truly flourish.  
    Utilizing the latest research on math education, Jo guides us through seven principles that can radically reframe our relationship with the subject: 
    • The power of mindset on learning 
    • Utilizing a visual approach to math 
    • The impact of physical movement and communication on understanding 
    • Understanding the spread and significance of mathematical ideas in the world 
    • The importance of connected and flexible knowledge 
    • New data on diverse teaching modes that work with different learning styles, not against them 
    • The value of diversity in learning mathematics—and beyond 
    When mathematics is approached more broadly, inclusively, and with a greater sense of wonder and play—when we value the different ways people see, approach, and understand it—we empower ourselves and gain a beneficial understanding of its value in our lives.
    Show book
  • Nature Near Home and Other Papers - cover

    Nature Near Home and Other Papers

    John Burroughs

    • 0
    • 0
    • 0
    Nature Near Home is one of many books on natural history by John Burroughs. It is full of simple observations about rural scenes and charming stories about animals, plants, and even people! Burroughs loves the creatures around him and derives great pleasure from his walks and studies in nature’s scenes. (Summary by Edith Phern)
    Show book