Gets a Long indicating the number of items in the SharedWorkspaceFiles collection. Read-only.
Syntax
expression.Count
expression A variable that represents a SharedWorkspaceFiles object.
Return Value
Integer
Example
The following example displays a message box with a count of the number of shared workspace files in the SharedWorkspaceFiles collection.
| Visual Basic for Applications
|
Sub Main() Dim swsFiles As Office.SharedWorkspaceFiles Set swsFiles = ActiveWorkbook.SharedWorkspace.Files MsgBox "There are " & swsFiles.Count & _ " file(s) vbInformation + vbOKOnly, _ "Collection Information" Set swsFiles = Nothing End Sub
|
120 acp acp120 ofv ofv120 olv olv120 pbv pbv120 pjv pjv120 ppv ppv120 sdv sdv120 vov vov120 wdv wdv120 xlv xlv120