An unbalanced basic recursive Binary Search Tree for Excel VBA with functions (insert, search, delete, in order, pre-order, post-order, minimum, and maximum)

Calling Python code from Excel with ExcelPython

by Eric Reynolds

ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.

Convert All Files to Searchable PDFs

by Igor Krupitsky

This program will convert office, text and image files to PDFs.

Converting discrete data points into a histogram using Excel VBA

by StewBob

This article gives a method for using Excel VBA to convert discrete data points into a histogram.

Create a DLL for Both VBA and Python Users

by Wayne Jin

Extend the function of Microsoft Office and Python

Create C# DCOM Simple Server to Use Excel RTD function to Access Real Time Data for Excel Spreadsheet

by junyaoxu

Step by step implementation of DCOM real time stock quote server with Yahoo financial API

Deconstruction of a VBA Code Module

by Mark Regal

This article is intended to build on the extensibility knowledge base with a focus on deconstructing a VBA code module.

Dynamic MSGraph.Chart in PowerPoint presentations

by Koen Vingerhoets

Add and handle MSGraph in PowerPoint slides

Excel and VBA - Query ListObject Directly

by Allen C. Copeland Jr

A guide on querying Excel ListObjects (Tables) by creating a state-machine out of synthesized objects that resemble a query language.

Excel ToolBox

by Patrice T

The Excel Tools I crafted to simplify my life as programmer

Excel, Jira, Rest API end to end example

by bradyguy

An end to end view of how to integrate Jira REST API's with Excel.

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Exploring Computational Number Theory (Part 3)

by William Hey

Factoring classic integers

Float Point Numbers as Approximates & Using Errors

by NewPast

Floating point numbers as approximates and understanding error happened when using single and double data types

Functors in VBA

by Yiannis Spyridakis

This articles describes the implementation of functors (of sorts) for VBA using C++ ATL.

Generate Access Reports from Tables

by Bhis

Back in 2008, I was doing some freelance work and had a chance to work on this MS Access Report project. The client dealt with employee benefits, claims, and payment reimbursements.

Home Book-keeping with Excel 2007

by Alexandros Pappas

This article proposes a way to do book-keeping for home use.

How Baseball Led to a Quest for Software Coding Optimization

by Randy C Finch

A search for efficient algorithms to find Ruth-Aaron pairs

How to Use GPU in VBA/Excel

by Excel-lent

This article shows how to compile and execute OpenCL code from VBA.

Indian Number Formatting of Currency in Microsoft Access and Excel

by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

Make a Countdown Timer Add-in for Powerpoint - Part 1

by Wayne Jin

A walkthrough to create a count down timer Add-in for Powerpoint

Manage business logic in Access forms

by Torsten Tiedt

Avoid event spaghetti code when business logic becomes complex.

Math Expression Evaluator for VBA

by W. García

A class module developed to evaluate mathematical expressions given as VBA strings

Microsoft Access Application Development Guidelines

by Marco Sorich

Some guidelines for developing better MS Access solutions.

Microsoft Office 2011 - VBA to the Macs

by Thomas Roll

Developing custom functionality for Microsoft Office 2011 for Mac in C and VBA

Office Programming Helper Indent VB Code

by NewPast

Indent code, add line numbers, err handling, add number to words and more, expose a .NET library to Microsoft Word, Excel, Power Point macros writers and Access VBA code

Recursive VBA JSON Parser for Excel

by Tim Ski

JSON parser for VBA class module, allows recursive data

Reflection in VBA (a CreateObject() function for VBA classes)

by Joel C Graff

A method for instantiating classes using Reflection.

Save all Outlook Mail Items to Separate Files

by E.F. Nijboer

Source code for saving mail items to separate files and keeping folder structure

Semi-Prime Ordered Sequences (Part 2)

by William Hey

Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Table Football (Game Tutorial)

by VisualMonsters

Simple game "table football", you can easily create and play with your friends and family

Using OpenAI ChatGPT and Anthropic Claude in Excel VBA

by Igor Krupitsky

This codes provides and example of how to use Chat GPT in your Excel Macro

Using User Defined Fields in Outlook

by Kudredin

Making use of the User Defined Fields to help better organize emails, and keep track of informaiton

VB6 and VBA: Creating a Variable and an Array that Points to Same Data

by EiadXP

This is a very fast way to access string (or other) data with minimum memory consumption.

VBA Enumeration Database

by Mark Regal

It is the intention of this article to add a measure of detail to all user defined enumerations through the creation of an enumeration database.

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

by Dracula

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

VBE CreateToolWindow

by Sam Gerené

Create a custom dockable window in the VBA editor.

Worksheet Forms using WPF style architecture

by Dave “DWC” Curry

This tutorial will show you a good starting point for a WPF style framework which aims to make creating and maintaining Excel-worksheet-forms easier.