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
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Allows users to inserts image into sheet, replacing old one, with ability to ...
2021Feb20
Converts https found in text into anchers < a > Comes with GetHref as bonus ...
2018May13