Records affected by sql Execute command https://docs.microsoft. ...
2018Sep1
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
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
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
A simple graphic illustrates the new HTML5 tags and differences against old ones
2021Apr16
Shortcuts to do certain commands in Windows (tested in Windows 7) Shutdown, ...
2019Jan1
Show or hide Excel ribbon from inside VBA Needed that in one of my projects
2018Dec30