Using same code in CutString3, this will search for matching items. Searches ...
2018May29
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
I faced an issue the past few weeks when trying to add my own icon to ...
Dec29
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Returns if a char was found between two defined characters. Like find if Loss ...
Nov22
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
2022Oct12
Cleans array of unwanted items This usually needed after you merge two arrays, ...
2021Sep22