Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Protect txt file into word doc with password
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
ReadBinaryBuffer
Reads file in binary mode as blocks Starts reading from start in sequential ...
2023Apr30
ReadBinaryChunk
Reads certain chunk of a file in binary. Used with large files (like ~7gb ...
2023Apr28
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
DB_Connect_Install
Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...
2020Mar24
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
DB_AllRows
Returns all rows found from an SQL Query as string Separated by row and column ...
2018Apr23
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
Similar codes
File_SettingRead + File_SettingSave
Reads and saves settings to Settings file, used asp here.
Similar to
2022Dec27
SettingRead_JR
Reads setting saved in columns J:R Just like SettingRead, but when we have ...
2018Jun26
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
2018Apr14
DB_Setting2Read + DB_Setting2Save
Reads and save setting into settings table per 2 IDs, similar to SettingRead ...
2018May31
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
SQL Date from DateTime
Extract Date from Datetime field in SQL An old method I found in my archive.
Nov29
DB_Setting1List + DB_Setting1List_NameValue
DB_Setting1List is to Returns list of SettingValues matching certain ...
2018May31
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Logging use of executable in Windows
Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...
2021Jun13
DBMySQLVBA API
An API to allow connecting to MySQL database from VBA (or VB6), found it a ...
2019Feb3
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29