hiskio

    VBA Notes for Professionals book

    Amazing collection of free programming books

    收集中
    免費
    Amazing collection of free programming books

    The Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

    Book created for educational purposes and is not affiliated with group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

    https://goalkicker.com/

    章節目錄

    • 1-1
      Content list
    • 1-2
      About
    • 1-3
      Chapter 1: Getting started with VBA
    • 1-4
      Section 1.1: Accessing the Visual Basic Editor in Microsoft Oce
    • 1-5
      Section 1.2: Debugging
    • 1-6
      Section 1.3: First Module and Hello World
    • 1-7
      Chapter 2: Comments
    • 1-8
      Section 2.1: Apostrophe Comments
    • 1-9
      Section 2.2: REM Comments
    • 1-10
      Chapter 3: String Literals - Escaping, non-printable characters and line-continuations
    • 1-11
      Section 3.1: Escaping the " character
    • 1-12
      Section 3.2: Assigning long string literals
    • 1-13
      Section 3.3: Using VBA string constants
    • 1-14
      Chapter 4: VBA Option Keyword
    • 1-15
      Section 4.1: Option Explicit
    • 1-16
      Section 4.2: Option Base {0 | 1}
    • 1-17
      Section 4.3: Option Compare {Binary | Text | Database}
    • 1-18
      Chapter 5: Declaring Variables
    • 1-19
      Section 5.1: Type Hints
    • 1-20
      Section 5.2: Variables
    • 1-21
      Section 5.3: Constants (Const)
    • 1-22
      Section 5.4: Declaring Fixed-Length Strings
    • 1-23
      Section 5.5: When to use a Static variable
    • 1-24
      Section 5.6: Implicit And Explicit Declaration
    • 1-25
      Section 5.7: Access Modifiers
    • 1-26
      Chapter 6: Declaring and assigning strings
    • 1-27
      Section 6.1: Assignment to and from a byte array
    • 1-28
      Section 6.2: Declare a string constant
    • 1-29
      Section 6.3: Declare a variable-width string variable
    • 1-30
      Section 6.4: Declare and assign a fixed-width string
    • 1-31
      Section 6.5: Declare and assign a string array
    • 1-32
      Section 6.6: Assign specific characters within a string using Mid statement
    • 1-33
      Chapter 7: Concatenating strings
    • 1-34
      Section 7.1: Concatenate an array of strings using the Join function
    • 1-35
      Section 7.2: Concatenate strings using the & operator
    • 1-36
      Chapter 8: Frequently used string manipulation
    • 1-37
      Section 8.1: String manipulation frequently used examples
    • 1-38
      Chapter 9: Substrings
    • 1-39
      Section 9.1: Use Left or Left$ to get the 3 left-most characters in a string
    • 1-40
      Section 9.2: Use Right or Right$ to get the 3 right-most characters in a string
    • 1-41
      Section 9.3: Use Mid or Mid$ to get specific characters from within a string
    • 1-42
      Section 9.4: Use Trim to get a copy of the string without any leading or trailing spaces
    • 1-43
      Chapter 10: Searching within strings for the presence of substrings
    • 1-44
      Section 10.1: Use InStr to determine if a string contains a substring
    • 1-45
      Section 10.2: Use InStrRev to find the position of the last instance of a substring
    • 1-46
      Section 10.3: Use InStr to find the position of the first instance of a substring
    • 1-47
      Chapter 11: Assigning strings with repeated characters
    • 1-48
      Section 11.1: Use the String function to assign a string with n repeated characters
    • 1-49
      Section 11.2: Use the String and Space functions to assign an n-character string
    • 1-50
      Chapter 12: Measuring the length of strings
    • 1-51
      Section 12.1: Use the Len function to determine the number of characters in a string
    • 1-52
      Section 12.2: Use the LenB function to determine the number of bytes in a string
    • 1-53
      Section 12.3: Prefer `If Len(myString) = 0 Then` over `If myString = "" Then`
    • 1-54
      Chapter 13: Converting other types to strings
    • 1-55
      Section 13.1: Use CStr to convert a numeric type to a string
    • 1-56
      Section 13.2: Use Format to convert and format a numeric type as a string
    • 1-57
      Section 13.3: Use StrConv to convert a byte-array of single-byte characters to a string
    • 1-58
      Section 13.4: Implicitly convert a byte array of multi-byte-characters to a string
    • 1-59
      Chapter 14: Date Time Manipulation
    • 1-60
      Section 14.1: Calendar
    • 1-61
      Section 14.2: Base functions
    • 1-62
      Section 14.3: Extraction functions
    • 1-63
      Section 14.4: Calculation functions
    • 1-64
      Section 14.5: Conversion and Creation
    • 1-65
      Chapter 15: Data Types and Limits
    • 1-66
      Section 15.1: Variant
    • 1-67
      Section 15.2: Boolean
    • 1-68
      Section 15.3: String
    • 1-69
      Section 15.4: Byte
    • 1-70
      Section 15.5: Currency
    • 1-71
      Section 15.6: Decimal
    • 1-72
      Section 15.7: Integer
    • 1-73
      Section 15.8: Long
    • 1-74
      Section 15.9: Single
    • 1-75
      Section 15.10: Double
    • 1-76
      Section 15.11: Date
    • 1-77
      Section 15.12: LongLong
    • 1-78
      Section 15.13: LongPtr
    • 1-79
      Chapter 16: Naming Conventions
    • 1-80
      Section 16.1: Variable Names
    • 1-81
      Section 16.2: Procedure Names
    • 1-82
      Chapter 17: Data Structures
    • 1-83
      Section 17.1: Linked List
    • 1-84
      Section 17.2: Binary Tree
    • 1-85
      Chapter 18: Arrays
    • 1-86
      Section 18.1: Multidimensional Arrays
    • 1-87
      Section 18.2: Dynamic Arrays (Array Resizing and Dynamic Handling)
    • 1-88
      Section 18.3: Jagged Arrays (Arrays of Arrays)
    • 1-89
      Section 18.4: Declaring an Array in VBA
    • 1-90
      Section 18.5: Use of Split to create an array from a string
    • 1-91
      Section 18.6: Iterating elements of an array
    • 1-92
      Chapter 19: Copying, returning and passing arrays
    • 1-93
      Section 19.1: Passing Arrays to Proceedures
    • 1-94
      Section 19.2: Copying Arrays
    • 1-95
      Section 19.3: Returning Arrays from Functions
    • 1-96
      Chapter 20: Collections
    • 1-97
      Section 20.1: Getting the Item Count of a Collection
    • 1-98
      Section 20.2: Determining if a Key or Item Exists in a Collection
    • 1-99
      Section 20.3: Adding Items to a Collection
    • 1-100
      Section 20.4: Removing Items From a Collection
    • 1-101
      Section 20.5: Retrieving Items From a Collection
    • 1-102
      Section 20.6: Clearing All Items From a Collection
    • 1-103
      Chapter 21: Operators
    • 1-104
      Section 21.1: Concatenation Operators
    • 1-105
      Section 21.2: Comparison Operators
    • 1-106
      Section 21.3: Bitwise \ Logical Operators
    • 1-107
      Section 21.4: Mathematical Operators
    • 1-108
      Chapter 22: Sorting
    • 1-109
      Section 22.1: Algorithm Implementation - Quick Sort on a One-Dimensional Array
    • 1-110
      Section 22.2: Using the Excel Library to Sort a One-Dimensional Array
    • 1-111
      Chapter 23: Flow control structures
    • 1-112
      Section 23.1: For loop
    • 1-113
      Section 23.2: Select Case
    • 1-114
      Section 23.3: For Each loop
    • 1-115
      Section 23.4: Do loop
    • 1-116
      Section 23.5: While loop
    • 1-117
      Chapter 24: Passing Arguments ByRef or ByVal
    • 1-118
      Section 24.1: Passing Simple Variables ByRef And ByVal
    • 1-119
      Section 24.2: ByRef
    • 1-120
      Section 24.3: ByVal
    • 1-121
      Chapter 25: Scripting.FileSystemObject
    • 1-122
      Section 25.1: Retrieve only the path from a file path
    • 1-123
      Section 25.2: Retrieve just the extension from a file name
    • 1-124
      Section 25.3: Recursively enumerate folders and files
    • 1-125
      Section 25.4: Strip file extension from a file name
    • 1-126
      Section 25.5: Enumerate files in a directory using FileSystemObject
    • 1-127
      Section 25.6: Creating a FileSystemObject
    • 1-128
      Section 25.7: Reading a text file using a FileSystemObject
    • 1-129
      Section 25.8: Creating a text file with FileSystemObject
    • 1-130
      Section 25.9: Using FSO.BuildPath to build a Full Path from folder path and file name
    • 1-131
      Section 25.10: Writing to an existing file with FileSystemObject
    • 1-132
      Chapter 26: Working With Files and Directories Without Using FileSystemObject
    • 1-133
      Section 26.1: Determining If Folders and Files Exist
    • 1-134
      Section 26.2: Creating and Deleting File Folders
    • 1-135
      Chapter 27: Reading 2GB+ files in binary in VBA and File Hashes
    • 1-136
      Section 27.1: This have to be in a Class module, examples later referred as "Random"
    • 1-137
      Section 27.2: Code for Calculating File Hash in a Standard module
    • 1-138
      Section 27.3: Calculating all Files Hash from a root Folder
    • 1-139
      Chapter 28: Creating a procedure
    • 1-140
      Section 28.1: Introduction to procedures
    • 1-141
      Section 28.2: Function With Examples
    • 1-142
      Chapter 29: Procedure Calls
    • 1-143
      Section 29.1: This is confusing. Why not just always use parentheses?
    • 1-144
      Section 29.2: Implicit Call Syntax
    • 1-145
      Section 29.3: Optional Arguments
    • 1-146
      Section 29.4: Explicit Call Syntax
    • 1-147
      Section 29.5: Return Values
    • 1-148
      Chapter 30: Conditional Compilation
    • 1-149
      Section 30.1: Changing code behavior at compile time
    • 1-150
      Section 30.2: Using Declare Imports that work on all versions of Oce
    • 1-151
      Chapter 31: Object-Oriented VBA
    • 1-152
      Section 31.1: Abstraction
    • 1-153
      Section 31.2: Encapsulation
    • 1-154
      Section 31.3: Polymorphism
    • 1-155
      Chapter 32: Creating a Custom Class
    • 1-156
      Section 32.1: Adding a Property to a Class
    • 1-157
      Section 32.2: Class module scope, instancing and re-use
    • 1-158
      Section 32.3: Adding Functionality to a Class
    • 1-159
      Chapter 33: Interfaces
    • 1-160
      Section 33.1: Multiple Interfaces in One Class - Flyable and Swimable
    • 1-161
      Section 33.2: Simple Interface - Flyable
    • 1-162
      Chapter 34: Recursion
    • 1-163
      Section 34.1: Factorials
    • 1-164
      Section 34.2: Folder Recursion
    • 1-165
      Chapter 35: Events
    • 1-166
      Section 35.1: Sources and Handlers
    • 1-167
      Section 35.2: Passing data back to the event source
    • 1-168
      Chapter 36: Scripting.Dictionary object
    • 1-169
      Section 36.1: Properties and Methods
    • 1-170
      Chapter 37: Working with ADO
    • 1-171
      Section 37.1: Making a connection to a data source
    • 1-172
      Section 37.2: Creating parameterized commands
    • 1-173
      Section 37.3: Retrieving records with a query
    • 1-174
      Section 37.4: Executing non-scalar functions
    • 1-175
      Chapter 38: Attributes
    • 1-176
      Section 38.1: VB_PredeclaredId
    • 1-177
      Section 38.2: VB_[Var]UserMemId
    • 1-178
      Section 38.3: VB_Exposed
    • 1-179
      Section 38.4: VB_Description
    • 1-180
      Section 38.5: VB_Name
    • 1-181
      Section 38.6: VB_GlobalNameSpace
    • 1-182
      Section 38.7: VB_Createable
    • 1-183
      Chapter 39: User Forms
    • 1-184
      Section 39.1: Best Practices
    • 1-185
      Section 39.2: Handling QueryClose
    • 1-186
      Chapter 40: CreateObject vs. GetObject
    • 1-187
      Section 40.1: Demonstrating GetObject and CreateObject
    • 1-188
      Chapter 41: Non-Latin Characters
    • 1-189
      Section 41.1: Non-Latin Text in VBA Code
    • 1-190
      Section 41.2: Non-Latin Identifiers and Language Coverage
    • 1-191
      Chapter 42: API Calls
    • 1-192
      Section 42.1: Mac APIs
    • 1-193
      Section 42.2: Get total monitors and screen resolution
    • 1-194
      Section 42.3: FTP and Regional APIs
    • 1-195
      Section 42.4: API declaration and usage
    • 1-196
      Section 42.5: Windows API - Dedicated Module (1 of 2)
    • 1-197
      Section 42.6: Windows API - Dedicated Module (2 of 2)
    • 1-198
      Chapter 43: Automation or Using other applications Libraries
    • 1-199
      Section 43.1: VBScript Regular Expressions
    • 1-200
      Section 43.2: Scripting File System Object
    • 1-201
      Section 43.3: Scripting Dictionary object
    • 1-202
      Section 43.4: Internet Explorer Object
    • 1-203
      Chapter 44: Macro security and signing of VBA-projects/-modules
    • 1-204
      Section 44.1: Create a valid digital self-signed certificate SELFCERT.EXE
    • 1-205
      Chapter 45: VBA Run-Time Errors
    • 1-206
      Section 45.1: Run-time error '6': Overflow
    • 1-207
      Section 45.2: Run-time error '9': Subscript out of range
    • 1-208
      Section 45.3: Run-time error '13': Type mismatch
    • 1-209
      Section 45.4: Run-time error '91': Object variable or With block variable not set
    • 1-210
      Section 45.5: Run-time error '20': Resume without error
    • 1-211
      Section 45.6: Run-time error '3': Return without GoSub
    • 1-212
      Chapter 46: Error Handling
    • 1-213
      Section 46.1: Avoiding error conditions
    • 1-214
      Section 46.2: Custom Errors
    • 1-215
      Section 46.3: Resume keyword
    • 1-216
      Section 46.4: On Error statement
    • 1-217
      Credits
    • 1-218
      You may also like

    常見問答

    您可以透過手機、平板或是電腦登入 HiSKIO 平台，在【我的學習】＞【我的書籍】頁面，選擇想看的電子書。

    猜你喜歡

    用戶評價

    | 收集中

    銷售方案