Take this ready-to-use VBA module for MS-Outlook, that lets you export all mail messages selected in the current Outlook email browser to the file system.

Gathering Bloomberg Data with Synchronous VBA Calls to the API

by Chris Spicer

This article illustrates the simplest possible way of retrieving data from Bloomberg via the VBA API.

Help for the Access 2000-2003 developer with 'Out of Memory' issues or problematic codebase

by Mike Baldini

The following code filters the specified database

How to Create Speedometer Gauge and Thermometer as a Chart in MS Access

by VBA55

Display data in chart as Speedometer or Thermometer graphic

Import Export Wizard

by Sachin Chandanshive

Read / Write data from CSV to Excel

Insert Outlook Contact Birthdays in Calendar

by Edzko

This macro can be inserted in Outlook 2000 to search all your contacts for birthday information. If the birthday does not appear in the calendar, then insert it. The macro will dump a small text file "c:\Outlook.log" that lists the activity.

Launching a VB.NET Class Library from an MS-Office Excel Ribbon

by veen_rp

A simple, step by step tutorial to set up an MS-Office Excel Ribbon, launch your own .NET applications from Excel and interact with the spreadsheet values.

Macro to Change the Color of all Equations in a Word Document

by Member 12994860

Change the Font Color of all Equations in a Word Document

Make Outlook E-mail and Appointment Alerts 'top most'

by maxitone

Use this if you're working in a fullscreen RDP session - for example - to see new e-mail or appointment alerts

Merge Excel Files into One Using VB Script

by Igor Krupitsky

How to merge multiple Excel files into one with the help of VB script

Merge Many Excel Files into one VBS

by Igor Krupitsky

This VBS will merge Many Excel files into one

Merge many Excel Worksheets into one using VBS

by Igor Krupitsky

This VBS will merge Many Excel Worksheets into one.

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

Microsoft Excel: How to Comment Cells

by Alexey Shtykov

Convert column numbers to range letters and add comments

MIME / B64 Outlook attachment joiner

by ErnestoNet

How to join the parts of a file across several mails in MIME / Base 64 format in outlook

Non-FormControl Checkbox in Excel with VBA

by Kudredin

How to use a normal Excel cell within a worksheet as a checkbox

Non-Recursive JSON Parser for VBA

by Vinolarium

Sample code for parsing JSON with deep-nested schemas in VBA.

Outlook Attachments Counter, Don't Send Mails Without Attachments Anymore

by Joan M

When you forget to attach an invoice and your customer doesn't alert you... well, you start thinking about methods to prevent it from happening again.

Parsing CSV Files Directly from VBA

by W. García

VBA solution for CSV parsing problem

PHP, VBA and SQL Useful Scripts

by Mirzakhmet Syzdykov

Development process in few steps with the help of scripting software

Querying CSV in a Like SQL Way from VBA [Microsoft Excel and Access]

by W. García

Fully VBA “Power Query” alternative for work with CSV files

Rounding Values Up, Down, By 4/5, Or To Significant Figures

by Gustav Brock

Generic VBA functions for all the normal rounding methods - of any value that VBA can handle.

Selecting and Importing Excel File and Sheet for import into Access

by Clifford Nelson

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Spread Sheet Integrated Progress Bar

by Bernster

How to use Excel conditional formatting features to simulate a progress bar in an Excel worksheet

Timestamp Converter for Excel (VBA)

by Member 10211581

Converts a column of timestamps with a format "hh:mm:ss.000" (or similar) to a column of cumlative decimal values of time in units of sec, min, hrs or days.

Use VBA to Make a Picture Transparent in Microsoft Office

by veen_rp

Why can't you set transparency to a picture in an MSOffice application? Well, you can use a clumsy work-around to create a shape and paste your picture from the clipboard. Here's the code to automate it from VBA.

Using Web Configs Key Value pair in classical Asp pages

by Shekhar Pankaj

Using Web Configs Key Value pair in classical Asp pages

VBA macro user interaction with SelectionBox

by uildriks

Introduces the SelectionBox for simple user interaction in Office macros, akin to the VBA InputBox

VBA: Excel / Word to PDF Encrypted / Password Protected

by algor-AG

VBA: Excel / Word programmatically save document as PDF encrypted / password protected.

Writing Excel UDFs and Macros in Python with ExcelPython

by Eric Reynolds

Learn how to easily substitute VBA with Python as Excel's scripting language with a library called ExcelPython