将初始打开目录设置为具有给定名称的文件夹

Option Explicit
'Stores block names & attributes for 1st inserted block of each
Public AllBlocks As Scripting.Dictionary
'Stores attributes for selected block
Public AllAttribs As Variant
'Macro for user interface
Public Sub Ua()
  Dim myFiles As Variant 'Stores filenames selected in array
  myFiles = GetFiles 'Store filenames selected by user in array
  
  'AllBlocks is a public variable
  Set AllBlocks = New Scripting.Dictionary 'Initialize storage
  BlockDialog.BlockPicked = "" 'Initialize check variable
  Set AttribDialog.AttribPicked = Nothing 'Initialize check variable
  TextDialog.DoUpdate = False 'Initialize check variable
  
  'If files are selected
  If IsArray(myFiles) Then
    Dim myDoc As AcadDocument 'Need a variable for a drawing
    'Get the first drawing selected by user
    Set myDoc = AcadApplication.Documents.Open(myFiles(0))
    GetBlocks myDoc, AllBlocks 'Get all attributed blocks in dwg
  End If
  
  'There may be no attributed blocks, so need to test
  If AllBlocks.Count > 0 Then BlockDialog.Show 'Show list of blocks
  
  'If a block was selected
  If BlockDialog.BlockPicked  "" Then
    'Store attributes from selected block in public variable
    AllAttribs = AllBlocks.Item(BlockDialog.BlockPicked)
    AttribDialog.Show 'Show list of attributes
  End If
  
  'If an attribute was selected
  If Not (AttribDialog.AttribPicked Is Nothing) Then
    TextDialog.Show 'Display dialog to get new string
  End If
  
  'If OK was hit in the TextDialog
  If TextDialog.DoUpdate Then
    'Change all the drawings the user selected
    ProcessDrawings myFiles, _
                    BlockDialog.BlockPicked, _
                    AttribDialog.AttribPicked.TagString, _
                    TextDialog.NewText
    
    'Inform the user things are done
    MsgBox "Process is complete.", vbOKOnly, "ABC's of VBA"
  Else
    myDoc.Close False 'Close drawing left open during cancel
  End If
End Sub
'Open all given drawings and change selected attribute
Private Sub ProcessDrawings(ByVal Dwgs As Variant, _
                            ByVal BlockName As String, _
                            ByVal TagName As String, _
                            ByVal NewText As String)
  'The following creates a selection set filter
  Dim fType(0 To 1) As Integer 'Stores DXF-style codes
  Dim fData(0 To 1) As Variant 'Stores filters
  fType(0) = 0: fData(0) = "INSERT" 'Filter for block insertions
  fType(1) = 2: fData(1) = BlockName 'Filter for specific block
  
  Dim openFilename As String 'Stores name of open drawing
  Dim myDwg As AcadDocument 'Stores each drawing in turn
  Dim mySS As AcadSelectionSet 'Stores selection set
  Dim myAtts As Variant 'Stores attributes for each insertion
  Dim i As Long, j As Long 'Declare two counters
  
  For i = 0 To UBound(Dwgs) 'Loop thru all drawings
    openFilename = GetOpenFilename(Dwgs(i)) 'Checks if file is open
    'If the drawing is open, just refer to open drawing
    If openFilename  "" Then
      Set myDwg = AcadApplication.Documents.Item(openFilename)
    Else 'Open the drawing
      Set myDwg = AcadApplication.Documents.Open(Dwgs(i))
    End If
    
    Set mySS = GetSS(myDwg) 'Get a selection set
    
    'Populate the selection set with specified block insertions
    mySS.Select Mode:=acSelectionSetAll, _
                FilterType:=fType, _
                FilterData:=fData
                
    For j = 0 To mySS.Count - 1 'Loop thru all selected blocks
      ChangeAttrib mySS.Item(j), TagName, NewText 'Change attribute
    Next j
    
    mySS.Delete 'Always delete a selection set when done with it
    myDwg.Close Not myDwg.ReadOnly 'Close drawing, saving changes
  Next i
End Sub
'Checks to see if the given fully-qualified filename is open
'Returns the filename without path if it is open
Private Function GetOpenFilename(fqnName As Variant) As String
  Dim i As Long 'Declare a counter
  'Loop thru all open drawings
  For i = 0 To AcadApplication.Documents.Count - 1
    'Use the document given below for its properties
    With AcadApplication.Documents.Item(i)
      'Compare two strings, if they match (equal 0) then return Name
      If StrComp(.FullName, fqnName, vbTextCompare) = 0 Then
        GetOpenFilename = .Name
        Exit For 'Since a match was found, exit the loop
      End If
    End With
  Next i
End Function
'Returns a named selection set
Private Function GetSS(ByRef theDoc As AcadDocument, _
                       Optional ByVal Name As String = "mySS") _
                       As AcadSelectionSet
  'Enable error handling, but just skip the error
  On Error Resume Next
  'Attempt to get the named selection set
  Set GetSS = theDoc.SelectionSets.Item(Name)
  GetSS.Clear 'Clear the selection set of any items
  'If this error occurred, the selection set didn't exist, create it
  If Err.Number = 91 Then Set GetSS = theDoc.SelectionSets.Add(Name)
End Function
'Change the given attribute in the given block reference
Private Sub ChangeAttrib(ByVal theBlock As AcadBlockReference, _
                         ByVal TagName As String, _
                         ByVal NewText As String)
  Dim myAtts As Variant 'GetAttributes returns an array
  myAtts = theBlock.GetAttributes 'Get the attributes
  
  Dim i As Long 'Declare a counter
  For i = 0 To UBound(myAtts) 'Loop thru all attributes
    With myAtts(i) 'For each attribute
      'If the current attribute is the correct one
      If .TagString = TagName Then
        .TextString = NewText 'change the attributes value
        Exit For 'Exit the loop, we are done
      End If
    End With
  Next i
End Sub
'Returns all the attributed inserted blocks in a drawings layouts
Private Function GetBlocks(ByVal theDoc As AcadDocument, _
                           ByRef BlockStore As Scripting.Dictionary)
  'Set dictionary's comparison mode to work with text
  BlockStore.CompareMode = TextCompare
  
  Dim aEntity As AcadEntity 'Stores each entity in turn
  Dim aLayout As AcadLayout 'Stores each layout in turn
  Dim aBlkRef As AcadBlockReference 'Stores a block reference
  For Each aLayout In theDoc.Layouts 'Loop thru all the layouts
    'The below condition is for performance, it excludes ModelSpace
    If Not (aLayout.ModelType) Then
      For Each aEntity In aLayout.Block 'Loop thru all entities
        'If the current entity is a block insertion
        If TypeOf aEntity Is AcadBlockReference Then
          Set aBlkRef = aEntity 'Cast the entity into a block ref
          'If the block insertion has attributes
          If aBlkRef.HasAttributes Then
            'Use a procedure to add block to dictionary
            'Need procedure for isolated error handling
            AddBlock BlockStore, aBlkRef.Name, aBlkRef.GetAttributes
          End If
        End If
      Next aEntity
    End If
  Next aLayout
End Function
'Adds a block name and its attributes to a dictionary
Private Sub AddBlock(ByRef BlockStore As Scripting.Dictionary, _
                     ByVal Name As String, _
                     ByVal Attribs As Variant)
  'Enable error handling, but just skip the error
  On Error Resume Next
  'Attempt to add block name and its attributes to the dictionary
  'If the block name already exists in the dictionary,
  'an error occurs. So this procedure just skips the duplicate.
  BlockStore.Add Name, Attribs
End Sub
'Display an open dialog, adds selected files to an array
Private Function GetFiles() As Variant
  'Stores the object created by the CommonDialog class
    Dim myOpen As CommonDialogProject.CommonDialog
  Set myOpen = CommonDialogProject.Init 'Create the object
  
  myOpen.DialogTitle = "Select drawings" 'Change the title
  myOpen.Filter = "AutoCAD Drawing files (*.dwg)|*.dwg|" & _
                          "AutoCAD Drawing template files (*.dwt)|*.dwt"
    myOpen.DefaultExt = "dwg"
  'Set flags to limit behavior of the dialog box
  myOpen.Flags = OFN_ALLOWMULTISELECT + _
                 OFN_EXPLORER + _
                 OFN_FILEMUSTEXIST + _
                 OFN_HIDEREADONLY + _
                 OFN_PATHMUSTEXIST
   myOpen.InitDir = FindPath("path\to\files\no\leading\or\trailing\backslashes")
   myOpen.MaxFileSize = 2048 'Increase buffer of filenames
  
  Dim success As Long 'Stores the return value from CommonDialog
  success = myOpen.ShowOpen 'Display the open dialog box
  'If the dialog was not cancelled get array of filenames
  If success > 0 Then GetFiles = myOpen.ParseFileNames
End Function
Private Function FindPath(ByVal path As String) As String
Dim X As Integer
For X = 67 To 69
   rVal = Dir(Chr(X) & ":" & path & "\*.*")
   If rVal  "" Then
     FindPath = Chr(X) & ":" & path
     X = 70
   Else
     FindPath = "C:"
   End If
Next X
End Function

MyOpen.InitDir = FindPath ("Program Files\Stored Data\Drawings")

Dim rVal As String 

myOpen.InitDir = FindPath("Drawings")