DevX Tips Bank: Visual Basic For Applications (vba)

Passing Strings Between Delphi DLL and VBA

Unlike other routines, this one doesn't need to pass the length of the returned string for …

Converting Numbers to Column Names in Excel 2007

While converting to Excel 2007, I had to update the column number to string code in my …

Count the Number of Cells Containing a Specified String in a Worksheet

Simply insert this function into a module to count the number of cells with a specified …

Convert Numbers to Excel Column Names

This algorithm converts column numbers (1-x) to Excel column names.

Using VBA in Access 97 Development

When developing Access 97 applications using VBA, you may have problems porting your …

Change Access Passthrough Query Definition

When the SQL SERVER is used as the database, and Access is the front-end application, …

Dynamically Change the Access Passthrough Query Definition

This is a useful tip if you are using SQL Server as your database and ...

Determing Empty Tables or Queries in MS Access

You can determine whether an Access table or query, accessed via RECORDSET OBJECT, …

Streamline Math in VBA

It's possible to streamline some calculation procedures in Excel and add calculation …

Zap Expired Docs

This VBA Microsoft Word routine purges a document when it's opened after a predefined …

Clear Out Data When Unloading Forms

When unloading a form, use the following piece of code behind a ...

Debugging Using the Query TopValues Property

I speed up the debugging of applications with queries that return large record sets by …

Not all Templates are Created Equal

Unlike templates in other Office 97 products, Word 97 templates provide a …

Using Registry Editing Functions

How do I get VB to edit the registry in runtime?