Search results 18

Sorted from new to old.

ANStrSort3

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

Feb20

CreateThumbSquare_IrfanView

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

Jan18

Refresh Table from View

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

2023Jul19

ANmaBatchCreate + ANmaBatchRun

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

2022Aug25

ANmaSQL_UpdateDateStatement

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

2022Jul4

ANmaSQL_InsertStatement

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

2022Jul3

ShapeName clicked

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

2022Feb4

OpenAnyFile

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

2022Jan28

Old cell value

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

2021Dec30

Execute exe embedded in Excel

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

2021Apr16

NextID_Reset

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

2020Mar31

DB_Connect_Install

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

2020Mar24

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

1 2