Codes Required
StartApp-IfNotStarted
Checks if application is already running, returns 1 or 0 My first function
Aug3
ANmaSearch_OrFriends
Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...
Jul30
ANstr_Column
Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...
Jul29
DownloadFile_Safe
Downloading file directly to machine without refreshing or going to another ...
Jul27
Quarter1stLastDate_FromQuarterText
Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...
Jul26
JSON_To_Table
An attempt to read json into table. This one is a work in progress, tested and ...
Jun6
ANmaSearch_ApostropheFriends
Searches for string inside string with apostrophe variations conversion
May27
ANmaHTMLTables_Combine2
Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...
May16
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Similar codes
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Arabic in MySQL
Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...
2023Apr12
Showing 4k (and more) images in BS5 modal
Allow users to browse and scroll through tons of images to select one (tried on ...
Nov7
Subtotal_Indirects
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
2021Nov26
HTMLTag + HTMLPair
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
CreateThumbSquare_IrfanView
Creates square thumb for an image, regardless of image aspect ratio It will ...
2024Jan18
Online Wordpress password hash generator
An online tool to generate password hash for wordpress, tried it just today ...
2020Feb13
Recently by developer
HTMLTable_FindTable
Reads < table .... < /table> found after index Have ability to opnly bring the ...
Sun 1PM
ANStrFind_AndOrRemove
Checks (and/or removes) if an item was found in list of items and return 1 if ...
Sun 1PM
ANmaSearch_AllWords_FromANStr
Checks if string has all words from ANStr inside Retuns 0 if not found or ...
Jan8
Random Codes
Arr_1Dim_2Str
Converts 1-dimension array into text. Meet Join. A way to convert array into ...
2023Aug14
Porting Excel/VBA into OpenOffice Calc
PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic
2019Feb8
