Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

USStandardToMetric

Converts US Standard Measure into a Metric Measure. Arguments: ...

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

SwapDate

Changes date format from US to International or from international to US. ...

Convert2SQLDate

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

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 ...

DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...