Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
To raise a friendly error message with option to show custom error number and ...
2018Jul7
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Find the user name (and domain) for logged in user for in an internal intranet ...
2020Feb23
2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...
2018Jun24
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
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
Open image using legacy PhotoViewer from Windows 7 Command line call to use ...
2021Aug25
Rounds time into nearest quarter up or down, half up or down based on argument ...
2019Jan9