Collection.Add method 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.Add method

Adds a member to a Collection object. Syntax object.Add item, key, before, after The Add method syntax has the following object qualifier […]

Collection.Add method