A list of small, stand-alone and straight-forward, VBS utilities
I've written some of these scripts, modified some others or just get a copy of an existing script (original author always mentioned and linked).
Try to establish a connection to a SQL database
This script will allow you to quickly check if access to your SQL Server database is possible.
The objective is to establish a connection and check if it works before starting, e. g., to investigate your program code or the permissions required for the user to use your tables, views, stored procedures,...
This script will only do this, i.e. try to connect to the database, which will eliminate the possibility of a login problem.
go to database/test_connection
Take advantage of Windows Desktop Search and very fast, get the list of MS Access applications present on the computer (local drives so also return files present, f.i. on a D: drive if you run the script from the C: drive; don't scan network drives).
Just adjust the searched extension for searching for any other type of files like .docx, .png, .xlsx, ...
This script is really, really fast but only works for local drives.
Scan a folder recursively and display the size of each folders (first level)
Get the list of files of the current folder + subfolders and generate a .csv file with files informations like path, size, extensions, author, ... making then easy to work with that list in Excel
go to folders/get_list_of_files
Display a select folder dialog box and then return then selected foldername
Sample script to demonstrate how it's possible to add an auto-update feature in a VBS script.
The script will check for newer version on GitHub and if there is one, the script will overwrite himself with that newer version.
Simple pattern VBS script for retrieving the list of MS Outlook objects like emails, contacts, ...
The current demo script will just echoed the email's subject in a DOS prompt
Adjust the constant for GetDefaultFolder to retrieve emails, contacts, ...
Retrieve messages over 14 days old from Outlook's Sent Items folder
Simple pattern VBS script for demonstrating how to retrieve the default's mail signature, create a new email, add a file to it and send (or display) the mail
See copyrights when mentionned or comments at the top of the script. If no one are mentionned, the author is Christophe Avonture.