Random codes

Random 24 Codes by our developers.

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

2023Apr5

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

MaggicSuggest

A good dropdown select, with HTML code From

2019Jun26

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

DB Functions (By AI)

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

2023Apr23

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

Nailthumb

Create thumbnail on fly using JS From

2019Jul31

Progressbar 10

CSS simple progressbar, customizable based on Bootstrap 3.3

2019Jan21

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

Filename_Clean

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

2023Jan11

img disable

Disable html img actions in website, like right-click menu, dragging and others. ...

2024Dec17

CSS3 spinner3

Pure css3 spinner or pre-loader Originally from http://codepen. ...

2019Apr30

CSS2PDF

Creates pdf from a css/html document. Looking to test it on next project ...

2024Dec20

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

Quarter1stLastDate_FromQuarterText

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

2024Jul26