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
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
ReNumber_IDColumn_inTable
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
LastInsertedID_SQL
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
IsEven + IsOdd
Returns True if integer is even by using IsEven While IsOdd, will returns True ...
2018Sep27
Page area and Page Setup functions (Unfinished)
Clear Excel print area, or set it, or read it, along with Page setup commands ...
2018Jun30