Development

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.

Learn Excel like a pro with easy-to-follow tutorials, step-by-step videos and free workbooks. Learn formulas, pivot tables, data validation, filters and more!.

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).