Collection object Archives - ExcelBaby

Learn

Excel Macro: List All Files in Folders and Subfolders

This Excel macro can list files (include hidden files) in a specified folder and subfolders, or files with a specific extension. Get it now!

UCase function DateLastAccessed DateLastModified Collection object Collection.Add method Collection.Remove method Size property Attributes property DateCreated Property For Each...Next statement With statement FileSystemObject.GetFolder method Dir function

Docs

Collection object

A Collection object is an ordered set of items that can be referred to as a unit. Remarks The Collection object provides […]

Collection object