Skip to content

Instantly share code, notes, and snippets.

View guwidoe's full-sized avatar

Guido Witt-Dörring guwidoe

41 followers · 20 following
  • EFS Consulting
  • Vienna
  • 08:15 (UTC +02:00)
View GitHub Profile
@guwidoe
guwidoe / GetLocalOneDrivePath.bas.vb
Last active September 3, 2026 06:07
VBA Function to get the local path of a OneDrive/SharePoint synchronized Microsoft Office file
'Attribute VB_Name = "OneDrivePathConversion"
'
' Cross-platform VBA Function to get the local path of OneDrive/SharePoint
' synchronized Microsoft Office files (Works on Windows and on macOS) and
' 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: 2026/07/15
@guwidoe
guwidoe / KeepRecalculatingRange.bas.vb
Last active December 2, 2022 19:56
VBA Sub for recalculating any Workbook/Worksheet/Range at any desired time interval
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
@guwidoe
guwidoe / CSIDL_VS_SSFC.md
Last active April 12, 2023 15:34
Obtaining Known Folders on Windows and Mac with VBA

Table comparing CSIDL and SSFC

Including example return values of

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 |

@guwidoe
guwidoe / GetOneDriveUrlPath.bas.vb
Last active June 2, 2025 13:41
Cross-platform VBA Function to get the OneDrive/SharePoint Url path/link from a local path of a locally synced folder
' 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)
'
' The functionality previously provided in this gist is now available in the
' 'GetRemotePath function from the following gist:
' https://gist.github.com/guwidoe/038398b6be1b16c458365716a921814d
' Please use that instead!
@guwidoe
guwidoe / VBA-AccurateTimer.bas.vb
Last active April 27, 2025 13:45
Cross-platform accurate timer for VBA code
' 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
@guwidoe
guwidoe / VBA-Keywords.md
Last active August 23, 2025 01:25
Exhaustive list of VBA Keywords, including categories reserved and non-reserved

Exhaustive lists of VBA Keywords and Symbols

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.

Table of Contents

  1. Keywords