Match3

Matching three values at the same time in three columns Just like Match the ...

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Convert2SQLDate

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

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

FixPath, IsThere, IsThere1 ...

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

Container Switcher

Using Classic ASP and cookies, allow users to personally choose between normal ...

Filesin_Coll + Filesin_Cells

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

1FileDB

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

1FileDB.zip

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

FindSheet

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