FileSystemObject.GetFolder method Archives

Learn

Excel Macro: List Files in Subfolders, Version 2

This Excel macro can list files in a specified folder and subfolders, and you can filter multiple file types. The difference from […]

Learn

gallery Element

The gallery element is designed to graphically display user options. A good example is the Styles gallery, which allows users to select […]

Folder.Files property FileSystemObject.GetFolder method

Learn

Excel Macro: Create, Copy, and Delete Folders

We can create, copy and delete specified folders using Folder object or FileSystemObject object in VBA. Get this VBA code now!

Err.Description property Copy method Folder.SubFolders property FileSystemObject.GetFolder method FileSystemObject.DeleteFolder method FileSystemObject.CreateFolder method FileSystemObject.CopyFolder method FileSystemObject.FolderExists method On Error statement

Docs

FileSystemObject.GetFolder method

Returns a Folder object corresponding to the folder in a specified path. Syntax object.GetFolder (folderspec) The GetFolder method syntax has these parts: […]

FileSystemObject.GetFolder method

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