Copyright (c) 2023 Guido Witt-Dörring (MIT License)
This document attempts to provide various exhaustive lists of VBA keywords and symbols using various categorizations. This is useful because the official documentation is convoluted and incomplete and it is very difficult to derive such lists from official sources.
If you find missing keywords or mistakes in any of the lists or have any suggestions, please don't hesitate to leave a comment below.
| ' Cross-platform VBA implementation of a high-precision timer. | |
| ' (Works on Windows and on macOS) | |
| ' | |
| ' Author: Guido Witt-Dörring | |
| ' Created: 2023/04/03 | |
| ' Updated: 2023/05/16 | |
| ' License: MIT | |
| ' | |
| ' ———————————————————————————————————————————————————————————————— | |
| ' https://gist.github.com/guwidoe/5c74c64d79c0e1cd1be458b0632b279a |
| ' Cross-platform VBA Function to get the OneDrive/SharePoint Url path (link) | |
| ' from a local path of a locally synced folder (Works on Windows and on macOS) | |
| ' | |
| ' Author: Guido Witt-Dörring | |
| ' Created: 2022/07/01 | |
| ' Updated: 2024/04/15 | |
| ' License: MIT | |
| ' | |
| ' ———————————————————————————————————————————————————————————————— | |
| ' https://gist.github.com/guwidoe/6f0cbcd22850a360c623f235edd2dce2 |
Including example return values of
SHGetFolderPath API function, and.NameSpace method of the Shell object.Code to genrerate this table for your own pc is provided below.
Dec | Hex | CSIDL code name | ssfC code name | SHGetFolderPathA return value | Equal? | oShell.NameSpace().Self.Path return value |
| Attribute VB_Name = "KeepRecalculatingRange" | |
| Option Explicit | |
| ' VBA Sub for continuously recalculating any Excel Workbook/Worksheet/Range | |
| ' at any desired time interval given in seconds. | |
| ' Author: Guido Witt-Dörring | |
| ' Created: 2022/11/14 | |
| ' Updated: 2022/12/02 | |
| ' License: MIT |
| ' VB.NET Function to get the local path of OneDrive/SharePoint synchronized | |
| ' Microsoft Office files | |
| ' | |
| ' Author: Guido Witt-Dörring | |
| ' Created: 2022/07/01 | |
| ' Updated: 2022/10/20 | |
| ' License: MIT | |
| ' | |
| ' ---------------------------------------------------------------- | |
| ' https://gist.github.com/guwidoe/bc875f4f25e0e970c62959d3c59da1d6 |
| 'Attribute VB_Name = "GetLocalOneDrivePath" | |
| ' | |
| ' Cross-platform VBA Function to get the local path of OneDrive/SharePoint | |
| ' synchronized Microsoft Office files (Works on Windows and on macOS) | |
| ' | |
| ' Author: Guido Witt-Dörring | |
| ' Created: 2022/07/01 | |
| ' Updated: 2024/04/23 | |
| ' License: MIT | |
| ' |