Provides access to the SharedWorkspaceFile objects in the SharedWorkspace. Read-only.

Syntax

expression.Files

expression A variable that represents a object.

Example

The following example lists the files saved in the current shared workspace.

Visual Basic for Applications 
 Dim swsFiles As Office.SharedWorkspaceFiles Set swsFiles = ActiveWorkbook.SharedWorkspace.Files MsgBox "There are " & swsFiles.Count & _ " file(s) vbInformation + vbOKOnly, _ "Collection Information" Set swsFiles = Nothing
ofv

See also: