Codes Required
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
Similar codes
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Filesin_Coll + Filesin_Cells
Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...
2018Jun10
DirTree.xlsb
Excel macro to show all files found in directory (including sub-directories) as ...
2019May20
IsThere2
Finds a file in giving its full path Similar to IsThere1 except this one uses ...
2020Jan10
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
SortedFiles
Get a sorted list of files in a directory using the File System Object (FSO) ...
2020Aug11
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
2018Jun11
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
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
CSVs2Sheets
Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...
2021Oct5
Auth_User
Find the user name (and domain) for logged in user for in an internal intranet ...
2020Feb23
Select Picker (Bootstrap4)
A nice light Bootstrap 4 select drop-down with search capability.
From
2019Jun20