Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

DeleteAllShapes

Delete all shapes in a sheet

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

FindName

Finds a name in a workbook, returns true or false

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

1FileDB.zip

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

RemoveHTML

Removes HTML code Basically anything between < and > There is a better ...