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
| # /// script | |
| # dependencies = [ | |
| # "google-genai", | |
| # "pillow", | |
| # "pathlib", | |
| # "python-dotenv", | |
| # ] | |
| # /// | |
| # Description: Generate variations of a person image using Google Gemini AI and create a GIF |
| '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: 2025/06/02 |
| 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_11351741/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); |