Skip to content

Instantly share code, notes, and snippets.

View Sven-Bo's full-sized avatar
🤓
Automating Excel

Sven Sven-Bo

🤓
Automating Excel
View GitHub Profile
@guwidoe
guwidoe / GetLocalOneDrivePath.bas.vb
Last active April 4, 2025 17:45
VBA Function to get the local path of a OneDrive/SharePoint synchronized Microsoft Office file
'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/10/01
' License: MIT
'
@jvarn
jvarn / excel-url-encode-decode.vb
Last active February 28, 2025 03:15
URL Encode and Decode VBA functions for Excel on Mac or Windows including UTF-8 support
Option Explicit
'------------------------------------------------------------------------------
' Module: URL Encode and Decode Functions
' Author: Jeremy Varnham
' Version: 1.1.0
' Date: 22 August 2024
' Description: This module provides two functions: URLEncode and URLDecode.
' These functions allow you to encode and decode URL strings,
' supporting ASCII, Unicode, and UTF-8 encoding.
@bpsib
bpsib / BBC-Radio-HLS.m3u
Last active April 13, 2025 12:02 — forked from stengland/BBC-Radio.m3u
BBC Radio Streams
#EXTM3U
#EXTINF:-1,BBC - Radio 1
http://as-hls-ww-live.akamaized.net/pool_01505109/live/ww/bbc_radio_one/bbc_radio_one.isml/bbc_radio_one-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1Xtra
http://as-hls-ww-live.akamaized.net/pool_92079267/live/ww/bbc_1xtra/bbc_1xtra.isml/bbc_1xtra-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1Dance
http://as-hls-ww-live.akamaized.net/pool_62063831/live/ww/bbc_radio_one_dance/bbc_radio_one_dance.isml/bbc_radio_one_dance-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 1 Anthems (UK Only)
http://as-hls-uk-live.akamaized.net/pool_904/live/uk/bbc_radio_one_anthems/bbc_radio_one_anthems.isml/bbc_radio_one_anthems-audio%3d96000.norewind.m3u8
#EXTINF:-1,BBC - Radio 2
@techjewel
techjewel / CapFirstLetter.js
Created May 22, 2020 15:35
Capitalize First Letter of Name Input Field in Fluent Forms
/*
* Add this js snippet in Form's JS box
*/
function capitalizeFLetter() {
var $input = $form.find('.ff-name-field-wrapper').find('input');
$input.on('blur', function() {
var string = $(this).val();
if(string) {
string = string[0].toUpperCase() + string.slice(1);
@spences10
spences10 / description.md
Created February 26, 2017 11:08
VBA project password crack

VBA Project Password Crack

SO link

SO answer

Paste the two modules into and empty solution with the workbook you want to crack then run the code in module2