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
'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 | |
' |
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. |
#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 |
/* | |
* 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); |