Finds 3 numbers in a string by ignoring characters between them. ' example ...
Cuts long string from certain character to certain character with option to ...
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...
Finds how many a string found inside larger string. Similar to Frequency but ...
Replace strings found in list of strings from inside a string, does that make ...
Runs SQL Command that needs no return This is primarily useful for CREATE, ...
Formats a number found at end of string to have additional leading zeros to ...
What is the Driver part in ConnectionString
Reads content of webpage with optional post data two main differences from
Returns an array of all table names in a database. needs valid OLE database ...
Sort list of strings in ascending or descending order using pure VBA, no ...
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
VBA-Excel function to connect to SQL Database server, in addition to ...
Script to list databases available in a server using ADODB connection From
Returns extended properties of a database, knowing the ADODB connection
An API to allow connecting to MySQL database from VBA (or VB6), found it a ...
50 chars max.