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
May1
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Random Codes
SQL Related posts
Steps to create related posts query in SQL. Index, catalog, matching posts for ...
2022Jul6
WorkbookSaveAsk_ANmar
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
ArrayRead + ArraySave
Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...
2018Apr15