UserChanged_Log4

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

SqlExec

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

Refresh Table from View

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

NumberEnding

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

DB Functions (By AI)

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

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

HyperlinkFunction

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

Shape_Select_or_CreateThenSelect

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

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

ANmaSQL_InsertStatement

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

iframeBtn

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

iFrameBtn.zip