Search results 76

Sorted from new to old.

QuickEncrypt plus others ...

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

Aug15

ANmAdd_ThenSort_2Columns

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

Jun1

SettingSave + SettingRead for NumberFormat

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

Apr19

UniqueRandomID in SQL

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

Feb18

Install/Uninstall SQLNativeClient DB driver

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

Feb8

ReadFileBytes

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

Jan15

ReNumber_IDColumn_inTable

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

2023Dec17

Latest records date and count

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

2023Nov2

ANmaFilter3

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

2023Oct13

SqlExec

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

2023Sep3

Refresh Table from View

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

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

ReadBinaryBuffer

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

2023Apr30

ReadBinaryChunk

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

2023Apr28

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

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

2023Apr22

1 2 3 4 5