Query DATETIME field using only date
SQL query where it can get data from a field where date is together with time based just on the…
Save file to SQL database
Code to save a file as binary into SQL database. Can be used in Excel and Access.
Find out file size
Simple script to find the size of the file.
Identify duplicates with formula
This simple formula will show if there is another duplicate value.
Find last used row or column
There are different ways to find last row or column which is populated.
Convert Column Number to Letter Or Letter To Number
Easy way to convert column letter to a number and column number to a letter.