Search results 76

Sorted from new to old.
Card image cap
QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Card image cap
ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Card image cap
UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

Card image cap
Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Card image cap
ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Card image cap
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image cap
DB connection driver

What is the Driver part in ConnectionString

Card image cap
ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

Card image cap
ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...