SharedWorkspaceFiles Collection
SharedWorkspace SharedWorkspaceFiles SharedWorkspaceFile |
A collection of the SharedWorkspaceFile objects in the current shared workspace.
Using the SharedWorkspaceFiles Collection
Use the Files property of the SharedWorkspace object to return a SharedWorkspaceFiles collection.
Dim swsFiles As Office.SharedWorkspaceFiles
Set swsFiles = ActiveWorkbook.SharedWorkspace.Files
MsgBox "There are " & swsFiles.Count & _
" file(s)
vbInformation + vbOKOnly, _
"Collection Information"
Set swsFiles = Nothing
Properties | Application Property | Count Property | Creator Property | Item Property | ItemCountExceeded Property | Parent Property
Methods | Add Method
Parent Objects | SharedWorkspace
Child Objects | SharedWorkspaceFile Object