VBA Notes for Professionals



Download free course VBA Notes for Professionals, pdf file on 202 pages by Stack Overflow Community.
The Visual Basic .NET Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow.

Table of contents

  • Getting started with VBA
  • Comments
  • String Literals - Escaping, non-printable characters and line-continuations
  • VBA Option Keyword
  • Declaring Variables
  • Declaring and assigning strings
  • Concatenating strings
  • Frequently used string manipulation
  • Substrings
  • Searching within strings for the presence of substrings
  • Assigning strings with repeated characters
  • Measuring the length of strings
  • Converting other types to strings
  • Date Time Manipulation
  • Data Types and Limits
  • Naming Conventions
  • Data Structures
  • Arrays
  • Copying, returning and passing arrays
  • Collections
  • Operators
  • Sorting
  • Flow control structures
  • Passing Arguments ByRef or ByVal
  • Scripting.FileSystemObject
  • Working With Files and Directories Without Using FileSystemObject
  • Reading 2GB+ files in binary in VBA and File Hashes
  • Creating a procedure
  • Procedure Calls
  • Conditional Compilation
  • Object-Oriented VBA
  • Creating a Custom Class
  • Interfaces
  • Recursion
  • Events
  • Scripting.Dictionary object
  • Working with ADO
  • Attributes
  • User Forms
  • CreateObject vs. GetObject
  • Non-Latin Characters
  • API Calls
  • Automation or Using other applications Libraries
  • Macro security and signing of VBA-projects/-modules
  • VBA Run-Time Errors
  • Error Handling
Pages202
Size2.3 MB
File typePDF
Downloads201
Created2022-02-03
LicenseCC BY-SA
Author(s) Stack Overflow Community
Cover of VBA Notes for Professionals

Download

  • Non-Programmer's Tutorial for Python 3

    This book is a tutorial for the Python 3 programming language designed for someone with no programming experience. Starting from no programming knowledge, the book teaches how to create programs with examples, explanations and exercises....

  • Introduction to Spring MVC

    This pdf tutorial is a step-by-step guide on how to develop a web application from scratch using the Spring Framework.Free training course material under 68 pages by Thomas Risberg, Rick Evans and Portia Tung....

  • Download Tutorial Laravel 5

    Easy Laravel 5 is an overview of the new PHP plateform, free training document material under 44 pages intended to beginners by W.Jason Gilmore....

  • Ruby Hacking Guide

    The Ruby Hacking Guide is a book that explains how the ruby interpreter (the official C implementation of the Ruby language) works internally. To fully understand it, you need a good knowledge of C and Ruby. This book is going to investigate ruby as a whole....

  • Essential Algorithms

    This book written to provide clear and concise explanation of topics for programmers both starting to learn the Algorithms as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

  • Arduino Development Cookbook

    The single-chip computer board Arduino is small in size but vast in scope, capable of bein..., download free Arduino tutorial in PDF (246 pages) created by Cornel Amariei ....

  • Introduction to Microsoft SharePoint 2016

    Download a free document of SharePoint 2016, a course in pdf on 64 pages for beginners....

  • Basic Programming Concepts

    The objectives of this tutorial are to introduce the fundamental concept of algorithm and the basic concepts of object-oriented programming, use the Java programming language, understand and apply good programming practices and evaluate your programmer skills....

  • iOS Development Tutorial

    Learning how to build application with IOS editor.Free PDF tutorial for beginners....

  • Software Project Management

    ...