ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

Resources.zip

Refresh Table from View

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

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

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 ...

ShapeName clicked

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

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip