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
Int function in ASP Classic (cint vs fix)
If you are looking for a function ASP Classic (VBScript) to do what Int() does ...
Feb6
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
Pps vs ppsx
PowerPoint slideshow file types and differences in file size. Bottom line, if ...
2020Dec20
