Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Convert items found in a column matching certain material into list in 1 cell ...
2019Jul30
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
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
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18