Sven Sven-Bo
🤓
Sven-Bo
/ create_3d_pie_chart.py
Created
June 24, 2024 17:30
This script demonstrates how to create a new Excel workbook, add data, insert a VBA macro, and execute it using the xlwings library in Python. The macro creates a 3D pie chart from the provided data.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| Author: Sven Bosau | |
| YouTube Channel: https://youtube.com/@codingisfun | |
| Website: https://pythonandvba.com | |
| Does this help you? Consider buying me a coffee here: | |
| https://pythonandvba.com/coffee-donation | |
| This script creates a new Excel workbook, adds data, inserts a VBA macro, and executes it using the xlwings library. The VBA macro generates a 3D pie chart from the data. | |
| """ |
Sven-Bo
/ GetLocalOneDrivePath.bas.vb
Created
September 7, 2024 10:30
— forked from guwidoe/GetLocalOneDrivePath.bas.vb
VBA Function to get the local path of a OneDrive/SharePoint synchronized Microsoft Office file
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| '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/07/08 | |
| ' License: MIT | |
| ' |
Sven-Bo
/ excel-url-encode-decode.vb
Created
February 28, 2025 03:15
— forked from jvarn/excel-url-encode-decode.vb
URL Encode and Decode VBA functions for Excel on Mac or Windows including UTF-8 support
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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. |
OlderNewer