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
Associate_Ext
Register an extension in Windows registry for extension with an application. ...
Nov25
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
ReadLastChars
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
ASPUsers
Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...
2022May4
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Range_SaveAsImage
Exports range to an image, something we wanted to be able to do for a while now. ...
2022Feb16
SaveAsHTML_Template
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Base64encode + Base64decode
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Similar codes
TextPercentageMatch
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator
2018Apr23
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
ANStrFind_AndOrAdd
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
Execute exe embedded in Excel
Execute exe file that embed inside Excel sheet This is for experimental, not ...
2021Apr16
X-editable
In-place editing with Twitter Bootstrap, jQuery UI or pure jQuery.
From
2019Aug31
