Example: Get sibling folders

This example gets the folder's siblings and the parent folder name.
Sub GetSiblingsAndParent() Dim oFolder As Folder Dim oFolders As Folders Dim oSibling As Folder Dim sFoldersParentName As String Dim sFolderList As String 'Create folders. TagDB.CreateFolder "Line1\Motor1" TagDB.CreateFolder "Line1\Motor2" TagDB.CreateFolder "Line1\Motor3" 'Set a folder. Set oFolder = TagDB.GetFolder("Line1\Motor1") 'Set the folder parent. Set oFolders = oFolder.Parent 'Set the folders parent name. sFoldersParentName = oFolders.Parent.Name 'Loop through all the folders and build a list. For Each oSibling In oFolders sFolderList = sFolderList & vbTab & oSibling.Name & vbCrLf Next oSibling 'Print the folder siblings. Debug.Print "The folder '" & oFolder.FullName & "' has the following siblings:" _ & vbCrLf & vbCrLf & sFolderList 'Print the folder parent name. Debug.Print "The folder '" & oFolder.FullName & "' has the parent:" _ & vbCrLf & vbCrLf & vbTab & sFoldersParentName 'Release objects. Set oFolder = Nothing Set oFolders = Nothing Set oSibling = Nothing End Sub
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal