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
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
Subtotal_Indirects
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
2021Nov26
ANmaSearch_SpaceFriends and LeftSpaceFriends
Searches for string inside string covering multiple possibilities for space ...
Jul30
ANmaSearch_QuoteFriends
Searches for string inside string with double-quote possibility If single ...
Jul13
CreateThumbSquare_IrfanView
Creates square thumb for an image, regardless of image aspect ratio It will ...
Jan18
Arabic in MySQL
Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...
2023Apr12
Quarter_to_Words
Convert Quarter code to text per special project requirements. A special ...
2020Dec17
Online Wordpress password hash generator
An online tool to generate password hash for wordpress, tried it just today ...
2020Feb13
Lined Paper in CSS
Lined paper CSS
From
2019Sep5
Recently by developer
RegSave, RegRead, RegDelete
Windows Registry read, save and delete branch node or key. Three functions use ...
Sun 9AM
Random Codes
UserChanged_Log4
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
SaveAsHTML_Template
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
CleanArray
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22
