02-AREAS

Python's magic methods - also known as dunder (double underscore) methods - can be used to implement a lot of cool things. Most of the time we u...

Python is known to come with "batteries included", thanks to its very extensive standard library, which includes many modules and functions that...

Beautiful, cross-platform & open-source tools for debugging, testing and building with HTTP(S), on Windows, Linux & Mac.

Automatically generate R package skeletons from application programming interfaces (APIs) that follow the OpenAPI Specification (OAS). The skeletons implement best practices to streamline package development.

I've recently jumped on the Obsidean bandwagon and absolutely love it. Though in time, researching the best way to get the most out of the application, I came across a few other Personal Knowledge...

up:: [[Home]] tags:: #map # LYT Kit MOC This is the "Map of Content" for the LYT Kit. Here you can: - Learn about the LYT Framework. - Learn about how MOCs literally re-write the game. - Create livi…

Johnny.Decimal is a system to organise projects (or your life, or anything else)

Source code used in dbadailystuff.com blog. Contribute to josepmv/dbadailystuff development by creating an account on GitHub.

List all Ole DB Providers in Powershell

This simple VBA function will check the user's registry and return the latest OLE DB provider from a list of supported providers that you can customize.

This simple VBA function will check the user's registry and return the latest ODBC driver from a list of supported drivers that you can customize.

This function will jump-start the process of converting long descriptions into meaningful abbreviations. It's great for creating "Code" columns in lookup tables.

Building Your LibraryThirteen years ago, I chose to maintain a folder of text files rather than a single Access database library. I’ve never once regretted that decision.No Longer SetMike WolfeThe Dependency TrainLet’s torture a train metaphor to illustrate the dangers of dependency chaining.No Longer SetMike WolfeCreating

This simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.

Python Enhancement Proposals (PEPs)

None

Tool that draws VBA structure of your MS Excel file.

This quick tutorial will have you writing custom events in VBA in no time.

Move over Rubberduck VBA and MZ-Tools. The next great VBE addin is going to be built with twinBASIC. Here are step-by-step instructions to get you started.

Without the knowledge, it can be challenging to write queries that retrieve the data you need in the format you need. An Excel and ...

In this master guide, you will learn about Openpyxl which is an open-source library that helps Excel automation using python.

Fully illustrated Excel tutorial + 300 examples. 100% free.

JKP Application Development Services, World-class Excel Application Development

MZ-Tools has a single goal: To make your everyday programming life easier. As an add-in to several Integrated Development Environment (IDEs) from Microsoft, MZ-Tools adds new menus and toolbars to them that provide many new productivity features.

VBA code examples. Addins for excel and powerpoint

AJP Excel information

ASAP Utilities is a friendly Excel add-in that saves our users a lot of valuable time. It contains many well-thought-out and useful tools that make working in Excel much easier and faster. Since 1999 it has grown to become probably one of the world's most popular add-ins for Excel.