1,486
社区成员
发帖
与我相关
我的任务
分享
Sub SelFolder()
Dim SelFolder$, spShell, spFolder, spFolderItem
On Error GoTo Err_Proc
Set spShell = CreateObject("Shell.Application")
Set spFolder = spShell.BrowseForFolder(0, "请选择文件夹!", 1, "")
Set spFolderItem = spFolder.Self
SelFolder = spFolderItem.Path
Debug.Print SelFolder
Exit Sub
Err_Proc:
If Err > 0 Then Exit Sub
End Sub