Copyright 2020 © QuinStreet Inc. All Rights Reserved
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?
Acceptable Use Policy
Terms of Service
California - Do Not Sell My Info