Search results 120

  2. Search results
  3. db
Sorted from new to old.
Card image
ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17
Card image
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6
Card image
PI

Returns a double representing the mathematical constant Pi

2018Jul5
Card image
DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30
Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26
Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21
Card image
HMatchIf

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

2018Jun16
Card image
Convert2SQLDate

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

2018Jun14
Card image
OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14
Card image
1FileDB

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

2018Jun9
Card image
RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2
Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31
Card image
DB_Setting2Read + DB_Setting2Save

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

2018May31
Card image
Connect to UDL

Use a UDL to make your connection to a database

2018May27
Card image
DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22
Card image
RandBetween

Generating random number between two

2018Apr25
12...78