Search results 22

Sorted from new to old.

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

Jul31

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

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

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

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

Evaluate

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

2020Feb16

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