Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Reads file in binary mode as blocks Starts reading from start in sequential ...
2023Apr30
Reads certain chunk of a file in binary. Used with large files (like ~7gb ...
2023Apr28
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
DB_Setting1List is to Returns list of SettingValues matching certain ...
2018May31
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
Add ribbon menu to certain macro-based workbook to run macro, will only be ...
2021Aug13
Saves/Reads selected theme into file. Used with Bootstrap 3 in most of my ...
2018Jul29