Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
Protects or unprotects a string giving a password Using XorD and similar to ...
2020Jan10
Adds a sheet to a workbook, after checking if workbook is open Checks if ...
2019Apr1
Protects and unprotects a file using password Creates another copy of the file ...
2020Jan10
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
Gives your user ability to select a workbook from list of open workbooks within ...
2019Apr3
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
Convert HTML text into DB-safe string, by converting some characters as below. ...
2019Feb7
A simple REST API technique reading record from Access mdb, then generates json ...
2019Feb1
Add dropdown with User login, logout into menu. This code used to replace "nav. ...
2018Dec18