3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
SQL select statement to convert list of IDs found in column (from more than row ...
Jan20
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
Checks if ID has been reset in SQL database table If yes, it will reset it and ...
2020Mar31
Find how many items in table, with column DateAdded is the latest DateAdded in ...
Nov2
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
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 ...
Apr30
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Show an image using irfanview or Windows 7 image viewer. Looking to add more ...
2020Feb16