No Clocks

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.

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.

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

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

The best online resource for all your Excel & VBA requirements

xlDynamic.com Home Page

Create a Table of Contents This code creates/updates a Table of Contents for a specific workbook.

This is a Microsoft Office Visual Basic for Applications Discussion Forum and Code Center

Excel VBA || Learn what is VBA and lots more. Also get access to the excel VBA programming Code for how to create a message box, input box, etc. Read on.

An update to the original concept that allows us to Refresh Power Queries with VBA. This approach will ONLY update Power Queries.

Spotify has a massive music database, and in this article we're going to look at how to connect to Spotify using Power Query.

Learn more about: Power Query M function reference

Best practices when working with Power Query

Power Query is used to filter, combine, and mash-up data from one or more supported data sources.

Glossary of terms for Visual Basic for Applications (VBA).

Glossary of terms for Visual Basic Editor (VBE).

Beautiful UI components and templates by the creators of Tailwind CSS.

Self-documenting makefiles · GitHub