3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
ASP based AJAX example to call mdb database using
2020Sep7
A simple REST API technique reading record from Access mdb, then generates json ...
2019Feb1
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
Find how many items in table, with column DateAdded is the latest DateAdded in ...
Nov2
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
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
List names in a certain workbook into sheet. And Deletes those names. You may ...
Jul9
Where can I find the SendTo folder? I always wanted to modify that list and ...
2019May15
2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...
2018Jun24