Download Item #5

Progress Dialog (for VBA programmers)

This ActiveX control creates a simple non modal floating progress dialog which contains a caption and a progress bar. This is mainly intended for use by Excel VBA programmers and provides a very efficient (dialog generated using only API calls) means of communicating progress to a user, without the restrictions of modal forms.

Formats: .zip , ProgressBar (20 k).
Last updated: July 06, 2005.

Back to Top

 

 

 

Download Item #6

Excel Controller (Status Bar, Application, Sub Classer and Printer)

This ActiveX DLL contains four objects:

Sub Classer for Excel. The sub classing object is to be used in conjunction with the  Application object (mentioned below). The object has the following events:

	Activate and deactivate.
	Minimise and maximise.
	Quit, close and destroy.

The sub classer also includes a class which enables run-time errors to be intercepted. The Excel run-time error dialog is replaced by a customizable dialog which allows the user to send bug report to a specified email address. The report includes, the name of the project, the routine name and the line of code that caused the error. NEW The sub classer also allows you to specify Excel's maximum and mimimun screen dimensions.

	Progress Bar. This enables the programmer to have total control over both the  progress bar and text contained within Excel's status bar.
	Application. Has many useful features like being able to set the application icons, clearing the clipboard, setting a system wide cursor, determining the operating  system version details, routines to restart/logoff and shut down the computer,  convert a array to a range and a host of other useful features. Now returns font and document property information.
	Printer. This object currently enumerates all the ports, servers and printers. The control will be extended in the near future to include control individual printer  methods and offer more properties.

The application sub classer also provides a global password dialog which protects ALL the projects in the VBA Editor. An example Workbook is included. The controls are Excel 5, 97, 2000 and XP compatible.

Formats: .zip, Full Install (1,796 k).
Last updated: July 31, 2003.
Notes :  
                July 31 2003 - Bug fixes + made XP compatible.
                January 31 2001 - Added new feature to control Excel screen dimensions.
                January 8 2000 - Fix to Backup proceedure.
                August 23 2000 - Fix to Sub Classer (Password Auto Complete).
                July 7 2000 - Made full install kit and upgraded dialogs.

Back to Top

 

 

 

Download Item #7

VB Code Header

This ActiveX DLL is designed to save time annotating sub routines and functions. The DLL will automatically link into the VB IDE and add two extra toolbar buttons. These buttons automatically insert a template routine (including error handling) along with a code header. The fields are customizable and the program is very simple to use. 

Formats: .exe , Header (60 k).
Last updated: January 31, 2001.
Notes : 
                Fixed date rounding error.            
                Automatic error handler added. 

Back to Top

 

Download Item #8

API routines for Dialogs

This sample code module contains a few useful routines to help VB and VBA programmers use the Windows API, to give them extra control over dialogs. Includes routines to return windows handles (VBA), disable the terminate dialog button (the "x" in the top right corner) and make a dialog system wide and appear above all other dialogs.

Formats: .bas , Dialogs (10 k).
Last updated: August 12, 2000.

Back to Top

 

 

 

Download Item #9

File DLL

This ActiveX DLL uses Windows API calls to extract and save data to text files and ini files. This DLL includes many extremely useful functions including enumerating the sections in an ini file, checking if a file is already open, converts paths to UNC format, deleting files, joining two files together, compares the contents of two files, shells an application and waits for that application to close, shells a documents default application (including printing documents), obtains a file creation time and routines to manipulate data to and from text and ini files to both 1 and 2d string arrays. Also includes object and demonstration workbook, which reads and extract files from compressed Cabinet files.

Formats: .zip , Full Installation (33 k).
Last updated: October 26, 2003.
Notes : 
                   Fixed 'FileJoin' (routine which joins files together).
                   Now converts paths to UNC format. 

Back to Top

 

 

 

Download Item #10

ListView Module

A useful collection of functions and subs to populate and query a ListView. The module contains API calls which remove the need to Redim Preserve arrays when retrieving the selected rows in a ListView.  The module also contains code to overcome several problems with populating ListView's including adding null items, and dealing with ListViews which reside in the MultiPage container. 

Formats: .bas , ListView (10 k).
Last updated: March 14, 2000.

Back to Top

 

 

 

Download Item # 11

Other useful routines

This module contains a number of miscellaneous routines and functions. Including the following routines:

	DLL Installer. Compares existing and new DLL version numbers then  installs the latest version. The routine all log DLLs changes to a text  file and creates backups of the original DLLs.
	Array handling routines (inc. sorting 1 and 2d arrays and removing items from arrays).
	Min, Max, Average and Standard Devation (both types).
	Routines to synchronously Shell and wait for applications to finish opening or terminate.

Formats: .bas , Other Module File (10 k).
Last updated: May 30, 2000.

Back to Top

 

 

 

Download Item # 12

Select a Machine DSN

This form contains code which uses the ODBC32 API to enumerate the machine DSNs. The code will allow the programmer to restrict the type of DSN show (i.e. can filter by DSN type), returns the DSN select by the user and allows the user to update the DSNs available.

An example call to the form would be:

' This will show all machine DSNs
SelectedDSN = FrmSelectDSN.SelectDSN("ALL")

OR
'Shows only Access DSNs
SelectedDSN = FrmSelectDSN.SelectDSN("Microsoft Access Driver (*.mdb)")

OR
'Returns all machine SQL Server DSNs 
SelectedDSN = FrmDatabasePath.SelectDSN("SQL Server")    

Formats: .exe , selectdsn (33 k).
Last updated: April 14, 2000.

Back to Top

 

 

 

Download Item # 13

Make a control array in VBA

The workbook contained in this download demonstrates how to make a control array using a class module in VBA. This overcomes the VBA limitation of not being able to assign a single routine to handle multiple control events. The download illustrates how to add controls to both forms and worksheets at runtime, using a class module to capture the events raised by the controls.

Formats: .exe , ControlArray (55 k).
Last updated: November 9th, 2000.

Back to Top

 

 

 

Download Item # 14

Ini File Class

This class contains all of the windows API required to load and save values to ini files. The class includes methods to save and load individual values, delete sections, enumerate sections, save sections and a number of other useful routines.

Formats: .cls , Ini File Class (16 k).
Last updated: December 16, 2003.

Back to Top

Download Item # 15

Data Encryption Class

The classes in this download illustrate two different methods of encrypting and decrypt data. The first class uses the XOR operator, whereas the second class uses the API from the advapi32.dll. An example workbook, modules and text file have been included to demonstrate these techniques.

Formats: .zip , Encryption Class (54 k).
Last updated: March 4, 2001.

Back to Top

Download Item # 16

FTP Class

This class provides a programatic interface to the FTP API. The class allows a programmer to connect, upload/delete files, make/delete and search directories. The downwload includes a module illustrating the uses of this class.

 

Formats: .zip , FTP Class (21k).
Last updated: Nov 4, 2004 (Bug Fixes).

Back to Top

 

 

Download Item # 18

Folder Watcher

The Excel workbook and Visual Basic Project in this download watch a folder for any changes to files of a specified type (inc.adding, deleting and modifying). The projects use an out of process Active X EXE to monitor the folders and are notified of any changes using events. A Setup program is included to install the relevant components.

Formats: .zip , Folder Watcher (55 k).
Last updated: December 15, 2004.
Notes : 
                   Bug Fixes to multiple instances and sub directory searching, March 16, 2005.
                   Performance optimisations, August 1, 2003.
                   Added Match 3, 2001.

Back to Top

Download Item # 19

Data Transfer Centre

This download contains an ActiveX Exe component and two demonstration Excel workbooks. These  demonstrate how to get round an age old problem of easily transfering data between applications. The ActiveX Exe can be connected to by any number of applications (inc. VB and VBA applications) and will distrubute any type of data to all of the listening applications or a single named listener. Each listener specifies a key, which can be unique or common to a group, and when the sender sends data it has an option parameter to tell the Data Center which listener/s are to receive the data. The control also allows the recipient to send back a return parameter which informs the Data Center it has received the data. There is no limit on the number of Data Centers or Listeners that can be created and all applications are free to use either both or just one of these components (i.e. to listen for data, send data or both).

Formats: .zip , Data Transfer Center (2,050 k).
Last updated: Feb 28, 2005.
Notes : 
                   Added example VB project and additional functionality.

Back to Top

Download Item # 20

Resource File Reader

This download reads/loads resource data stored in DLLs/EXEs. It is the equivalant to the VB functions LoadResData and LoadResString, with the advantage that it lets you read data from external files. You will need to run Regsvr32 on the VBusersResource.dll (use the "Run" menu and enter "regsvr32 PathToDLL\VBusersResource.dll") before you can the use demonstration project ResourceReader.vbp. The VBusersResource.dll will enumerate the different types of resource data stored in the file, including Icons, Bitmaps, Cursors and Custom data. You can then extract the data to string, binary and picture formats or save the data to disk.

Formats: .zip , Resource File Reader (50 k).
Last updated: May 7, 2001.
Notes : 
                  New Download.

Back to Top

Download Item # 21

Multi-Threading Demonstration

This download contains Visual Basic source code which demonstrates a technique for creating Multi-Threaded applications in Visual Basic. The example project demonstrates how to create userforms on different threads of execution, thereby allowing each form to process information independently. Note, the VB IDE does not support Multi-Threading so you will need to run the compiled ActiveX EXE to view the results.

Formats: .zip , Multi-Threading Demonstration (15 k).
Last updated: May 24, 2001.
Notes : 
                  New Download.

Back to Top

Download Item # 22

Error Logging Class

This download contains a Visual Basic Class Module which enables the user to log useful information to a text file. An example of how to call the class can be found in the declarations section of the class.

Formats: .cls , Error Logging Class (19 k).
Last updated: Nov 30, 2001.
Notes : 
                  New Download.

Back to Top

Download Item # 23

ActiveX Timer

This download contains a Visual Basic Project which uses API calls to create a timer. Because the Timer in not a Form Control it can be placed in a class module and declared using WithEvents. An example project is included.

Formats: .zip , ActiveX Timer Project (19 k).
Last updated: Jan 30, 2002.
Notes : 
                   New Download.

Back to Top

Download Item # 24

Easy FTP

This download contains one of the cheapest, simplest FTP applications. Using right clicking to connect and upload and download files of any type. With the look and feel of Windows Explorer� you can transfer and view remote files with ease.

Click here for more information about Easy FTP (commercial download).

Back to Top

Download Item # 25

Process Debugger

This download will be of little use to the majority of VB developers, but extremely useful to a few. In a nutshell, it shows you who to use the windows debugger to view your compiled EXE running. The download shows you which threads are running and even demonstrates how to do the equivalent of Debug.Print in your compiled code!

Formats: .zip , Proces Debugger (25 kb).
Last updated: November 14, 2002.
Notes : 
                   New Download.

Back to Top

PC eGuardian

This download has been developed in response to several requests from parents who where concerned that they where unable to monitor what their children where doing on their home PCs. Installing this application will give peace of mind to these parents as it will discretely monitor every web site visited and everything typed (inc. emails). It even records the name of the web site/chat room and the date and time it was accessed.

Click here for more information about PC eGuardian (commercial download).

Back to Top

Download Item # 27

Standard Output Component

This download is the most robust, widely used component for integrating complex non homogenous IT systems. The component enables your VB applications to read AND write to and from standard output. This gives your VB applications the power to shell ANY processes (inc. DOS batch files, perl scripts etc) and capture it's output. It also enables you to return exit process codes and has a host of other properties to give you complete control over the way you talk to external processes. The download includes examples in VB and VBA (Excel).

Now COMPLETELY FREE to users of this site (was $30)!!!

Click here to download.

Last updated: Jan 05, 2005.

Asynchronous File Copier

This download contains a component which performs multithreaded copy operations. This is extermely useful when copying a large number/volume of files to a remote network location. An example Excel workbook is included to demonstrate how to use the component.

Note, just open (run) the "FileCopyAsync.exe" file to install this component.

Formats: .zip , Multithreaded FileCopying Component (19 k).
Last updated: Dec 13, 2003.
Notes : 
                   New Download.

Back to Top

Temporary Table Class

This download contains a VB Project and an Excel Workbook which demonstrate a quick method for converting a large list of items that you wish to join against into a temporary table. This will reduce the size of your SQL select statements as you will no longer need to use 'WHERE FIELD1 IN ( ... A LONG LIST OF COMMA SEPERATED ITEMS ... )' because you can just join on the #table you have created. An example routine is given in both the VB and VBA downloads.

Formats: .zip , Temporary Table Class (24 k).
Last updated: Mar 22, 2004.
Notes : 
                  New Download.

Back to Top

Excel Auto Backup Utility

This extremely useful utility performs periodical backups on all unsaved Excel workbooks. However, unlike the AutoSave addin it does not overwrite your current workbook (which can be extremely annoying if you want to abandon your changes). Instead the application creates an versioned copy of this file in a backup directory.

The application also allows you to specify the following:

1. How many days worth of data the utility will store.
2. The path to store the backups in.
3. Whether to run in silent mode.
4. How frequently to perform the backups.

Formats: .zip , Excel Auto Backup Utility (1564 k).
Last updated: Oct 30, 2005.
Notes: 
                  Bug fixes (problem with backups when in print preview mode).
                  Backup Toolbar is now moveable.

Back to Top

Process Wide Keyboard Hook DLL (VB + VBA)

This download provides a process wide method of capturing keyboard events in your VB and VBA applications. If you want a particular hot key to trigger a specific event then use this DLL to capture the keypress. Note, the DLL will also let you disable invidual keys.

The download includes a demo VB project and Excel Workbook.

VB to C# Inter Application Communicator

If you have an existing VB application and are trying to write new code in .NET and want the two applications to talk to each other, then this download is for you.

The VBusers.Interop.dll included in this download enables a VB executable to talk with a C# executable and vise versa. The dll allows a developer to connect two applications together and send extremely lightweight messages (text and numeric) between them - thereby allowing VB and C# applications to interact with each other (note, will also work from VB to VB and C# to C#).

The download includes example VB and C# projects, so you can see how simple it is to connect two applications together.

After downloading the application you will need to run "Install.bat" to install VBusers.Interop.dll into the GAC. If you have problems with this, please check the paths in this file are correct (note, you will need v1.1 of the .NET Framework to use dll).

PS. Thanks to Gordon Willmot for his help with this project.

Formats: .zip , AppLinker dll and Example Code (41 k).
Last updated: Sep 24, 2005.
Notes: 
                  New Download.
Back to Top

"Path" Environment Variable Compactor and Cleaner

This simple free application compacts and cleans both the User and System "Path" environment variables. Both these environment variables are subject to 1023 and 2046 length limits on Win2k and XP respectively. This application helps maintain these variables by compacting the paths to DOS 8.3 format, removing duplicate paths and removing any entries which point to missing directories.

Formats: .zip , Path Cleaner and Compactor (11 k).
Last updated: Jun 15, 2007.
Notes : 
                   Added better compaction - removes users paths if in system path.

Back to Top