Syntax

expression.FolderName

expression A variable that represents a SharedWorkspaceFolder object.

Remarks

The FolderName property returns the subfolder name in the format parentfolder/subfolder. For example, if the shared workspace contains a folder named "Supporting Documents", the FolderName property returns Shared Documents/Supporting Documents.

Example
The following example displays the number of subfolders in the shared workspace and their names.

Visual Basic for Applications 
 Dim swsFolder As Office.SharedWorkspaceFolder Dim strFolderInfo As String strFolderInfo = "The shared workspace contains " & _ ActiveWorkbook.SharedWorkspace.Folders.Count & " folder(s)." & vbCrLf If ActiveWorkbook.SharedWorkspace.Folders.Count > 0 Then For Each swsFolder In ActiveWorkbook.SharedWorkspace.Folders strFolderInfo = strFolderInfo & swsFolder.FolderName & vbCrLf Next End If MsgBox strFolderInfo, vbInformation + vbOKOnly, _ "Folders in Shared Workspace" Set swsFolder = Nothing
folder Folder Name foldername foldername property ofv

See also: