ReadBinaryBuffer

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

ReadBinaryChunk

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

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

ANmaSQL_InsertStatement

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

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

Frm77.zip

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

Frm81.zip

GenerateThumbnail.php

Generates thumbnail of an image and saving it in certain folder. Edit php to ...