Private Sub Worksheet_Change(ByVal Target As Range)On Error Resume NextIf Target.Column = 3 Then MkDir "\\USER-20171225QG\Users\Public\文件\商川客户文件\" & Target.Value End IfEnd SubPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)If Target.Column = 3 And Target <> "" ThenShell "explorer.exe " & "\\USER-20171225QG\Users\Public\文件\商川客户文件\" & Target.Text, vbNormalFocusEnd IfEnd Sub