Latest Articles
Run Excel VBA
Script to open Excel spreadsheet and run VBA code using Powershell.
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.