Codes Required
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
File_SettingRead + File_SettingSave
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
FontAwesome Custom icons issue
I faced an issue the past few weeks when trying to add my own icon to ...
Dec29
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Generate_PowerPoint
Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...
2020Dec22
Animated form exit
Exit form with shrinking Shrinks the form, Pushes the form to the bottom of ...
2020Feb16
MatchIf (aka VMatchIf)
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16