这是一般使用的打开文件夹的代码,你把路径改一下
Private Sub CommandButton1_Click()
Dim Obj As Object, Path1
Set Obj = CreateObject("shell.application")
Set Path1 = Obj.BrowseForFolder(0, "选择要打开的文件夹:", 0)
If Not Path1 Is Nothing Then
Obj.Open (Path1.self.path)
End If
End Sub