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
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
2022Aug24
Imports rows from multiple sheets of a workbook into final sheet along with ...
2020Nov11
Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...
Feb2
Searches for string inside string with double-quote possibility If single ...
Jul13
Redirect using HTML Sometimes you need to do what you need to do The 0 in ...
2019May3
This script will take the results of a query and sets up number of records per ...
2018Apr18