VBA

Great Reads

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

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.

A Tree-View Control Using an MS Access Table and Form

by RB Starkey

How to create a tree-view control using an Access table and form.

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.

Latest Articles

PHP, VBA and SQL Useful Scripts

by Mirzakhmet Syzdykov

Development process in few steps with the help of scripting software

Create a DLL for Both VBA and Python Users

by Wayne Jin

Extend the function of Microsoft Office and Python

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

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

All Articles

top

VBA

Exploring Computational Number Theory (Part 1)

31 May 2016 by William Hey

Classical number theories

.NET

MS-Excel

VBA

VS2005

mathematics

MS-Access

Excel, Jira, Rest API end to end example

12 Apr 2016 by bradyguy

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

A Tree-View Control Using an MS Access Table and Form

16 Jul 2013 by RB Starkey

How to create a tree-view control using an Access table and form.

Semi-Prime Ordered Sequences (Part 2)

31 May 2016 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)

6 Jul 2021 by VisualMonsters

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

Exploring Computational Number Theory (Part 3)

26 Mar 2018 by William Hey

Factoring classic integers

Convert All Files to Searchable PDFs

26 Mar 2019 by Igor Krupitsky

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

VBScript

VBA

Manage business logic in Access forms

8 Mar 2012 by Torsten Tiedt

Avoid event spaghetti code when business logic becomes complex.

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

31 Oct 2022 by Wayne Jin

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

VBA

Generate Access Reports from Tables

24 Jun 2014 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.

Using User Defined Fields in Outlook

27 Jul 2012 by Kudredin

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

Excel and VBA - Query ListObject Directly

9 Nov 2014 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.

VBA

Office

Design

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

4 Oct 2022 by junyaoxu

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

.NET

VBA

DCOM

Create a DLL for Both VBA and Python Users

6 Dec 2022 by Wayne Jin

Extend the function of Microsoft Office and Python

Python

VBA

Worksheet Forms using WPF style architecture

21 Jun 2016 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.

Indian Number Formatting of Currency in Microsoft Access and Excel

1 Feb 2021 by Gustav Brock

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

VBE CreateToolWindow

5 Jan 2012 by Sam Gerené

Create a custom dockable window in the VBA editor.

Dynamic MSGraph.Chart in PowerPoint presentations

26 Aug 2014 by Koen Vingerhoets

Add and handle MSGraph in PowerPoint slides

Windows

VBA

How Baseball Led to a Quest for Software Coding Optimization

18 Sep 2018 by Randy C Finch

A search for efficient algorithms to find Ruth-Aaron pairs

How to Use GPU in VBA/Excel

16 May 2022 by Excel-lent

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

Office Programming Helper Indent VB Code

1 Mar 2020 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

Microsoft Office 2011 - VBA to the Macs

22 Aug 2014 by Thomas Roll

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

HTML

VBA

VBA Enumeration Database

8 Jan 2014 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.

VBE

VBA

enum

Deconstruction of a VBA Code Module

31 Dec 2013 by Mark Regal

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

VBE

VBA

Recursive VBA JSON Parser for Excel

24 Oct 2014 by Tim Ski

JSON parser for VBA class module, allows recursive data

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

2 Mar 2011 by Joel C Graff

A method for instantiating classes using Reflection.

Windows

VBA

Dev

Float Point Numbers as Approximates & Using Errors

1 Apr 2017 by NewPast

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

Math Expression Evaluator for VBA

1 Mar 2022 by W. García

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

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

2 Mar 2017 by Dracula

VBA Macros Provide Yahoo Stock Quote Downloads in Excel 2007

Converting discrete data points into a histogram using Excel VBA

3 Jun 2013 by StewBob

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

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

10 Mar 2014 by EiadXP

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

Functors in VBA

7 Mar 2012 by Yiannis Spyridakis

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

Microsoft Access Application Development Guidelines

15 Jan 2013 by Marco Sorich

Some guidelines for developing better MS Access solutions.

Save all Outlook Mail Items to Separate Files

16 Jul 2010 by E.F. Nijboer

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

Cloud Service to Automate Windows Desktop Applications

2 Mar 2011 by Won Dong

To utilize cloud service as an anonymous desktop environment in Amazon S3 and EC2 Windows instances

Calling Python code from Excel with ExcelPython

3 Sep 2013 by Eric Reynolds

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

Home Book-keeping with Excel 2007

26 Jan 2015 by Alexandros Pappas

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

A Very Basic Recursive Binary Search Tree For Excel VBA

24 Feb 2019 by WhiskeyBeforeWater

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