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
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 ...
Apr30
Random Codes
LastRow_Remove
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
15 Datestamps
15 pure CSS date stamps to be used or Calendar view of a date, something I ...
2019Jan15
ArrayRead + ArraySave
Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...
2018Apr15