Search results 49

Sorted from new to old.
Card image
ReadBinaryBuffer

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

Card image
ReadBinaryChunk

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

Card image
ReadLastChars

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

Card image
Dropdown button commands

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

Card image
ANmAdvancedFilter

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

Card image
ANmaSQL_UpdateDateStatement

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

Card image
ANmaSQL_InsertStatement

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

Card image
Too large procedures

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

Card image
COUNTIFS as Rank

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

Card image
fNMRPrgs, Full-form progress bar (frm77)

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

Card image
Frm81 - FullDetails

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

Card image
GenerateThumbnail.php

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

Card image
ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

Card image
Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

Card image
Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

Card image
ANBSThumbImg + ANBSThumbLink

Creates thumb of an image with or without link to original Use ANBSThumbLink ...