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
2018Apr23
Grandchildren files and count
Returns list of files in 2 level folders Will not find files as children of ...
Jan11
CreateZipFiles_7Zip
Create zip from list of files listed in List_of_Files separated by comma. The ...
2018Jul14
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
SortedFiles
Get a sorted list of files in a directory using the File System Object (FSO) ...
2020Aug11
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
FilesIn_Array and FoldersIn_Array
Return list of files in a folder back as array.
Similar to
Aug15
SheetName
Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...
2018Aug23
