Codes Required
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
Similar codes
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
2018Nov25
ImagesIn_User
Gets images in a folder where filenames start with "User" Similar to function ...
2019Dec31
IsThere1_Image
Searches for an image and return the file extension of found, or returns null ...
2019Dec7
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
LoadPicture_Safe
Loads an image into VBA image control without knowing its extension If file ...
2018Jul7
BrowseImage
Asks user to select an image and returns full path and name of selected image ...
2020Dec19
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
RandomImage
Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...
2018Aug10
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Random Codes
X-editable
In-place editing with Twitter Bootstrap, jQuery UI or pure jQuery.
From
2019Aug31
TeeOpen_ProtectTee + TeeOpen_UnprotectTee
Protect or unprotect a workbook (already open) remotely from another workbook ...
2019Jun2
Ordinal
Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...
2018Jun24