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

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

RandomUniqueID_Sheet

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

InSheet_ChangeImage

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

Reset ID Column

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

LastInsertedID_SQL

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

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

Embed fonts in Word doc

Embed fonts used in document, to make it available on any machine