ReadBinaryChunk

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

DB Functions (By AI)

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

WordPress - Excel functions (AI)

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

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

CSVs2Sheetsv0.2.xlsb.zip

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...