Table of contents
Collapse the table of content
Expand the table of content

SharedWorkspace.Files Property (Office)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

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

Note Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.


expression. Files

expression A variable that represents a SharedWorkspace object.


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

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

See also


SharedWorkspace Object

Other resources

SharedWorkspace Object Members

© 2018 Microsoft