Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31
This will tests to see if strQuotedString is wrapped in quotation marks, and, ...
2018Jul3
Build a string from a certain column in html table (using < table, < tr, and < ...
Mar14
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Collect strings matching search from a longer string. I used it to concatenate ...
Jan17
Bootstrap color picker
From
2019Jun27
Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...
2018Jul14
Detects active desktop screen resolution and location of taskbar (with some ...
2018Jun17