Search results 24

Card image cap
UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

Card image cap
SqlExec

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

Card image cap
Refresh Table from View

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

Card image cap
NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image cap
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image cap
ANmaSQL_InsertStatement

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

Card image cap
iframeBtn

A button in iframe, to run certain command and return status to end user ...

iFrameBtn.zip

Card image cap
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image cap
InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Card image cap
Reset ID Column

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