Random codes

Random 24 Codes by our developers.

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

2024Apr3

IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

2018Sep5

ANmaDB functions

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

2019Apr14

Embed fonts in Word doc

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

2019Jan7

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

OneDrive Reset

Reset OneDrive because I am a heavy OneDrive user. Most recent instructions, ...

2024Mar5

Checks if URL is valid

Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...

2018Dec9

SqlExec

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

2023Sep3

bootstrap-linkpreview

Preview link js script uses jquery and bootstrap From

2023Nov3

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

FS_CreateUserFolder

Creates a folder for a user, usually after sign up or login for first time. ...

2018Jul9

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1