|
本帖最后由 lightsnow 于 2020-7-20 11:11 编辑
Sub WriteFolderInfo()
'年代已久代码来源不详
Dim shApp As Object, path1 As Object, Path2 As String, LP As Boolean, AF As Boolean, Down As VbMsgBoxResult
Down = MsgBox("是否创建链接?", vbYesNo + vbDefaultButton2, "提示")
If Down = vbYes Then LP = True
AF = True
Set shApp = CreateObject("Shell.application")
Set path1 = shApp.BrowseForFolder(0, "请选择文件夹", 0, 17)
If path1 Is Nothing Then
Exit Sub
End If
Path2 = IIf(IsError(path1.Items.Item.path), path1.Title, path1.Items.Item.path)
'ActiveWorkbook.Worksheets.Add
Workbooks.Add
ActiveSheet.Outline.SummaryRow = xlAbove
Application.ScreenUpdating = False
WriteInfo Path2, 1, 1, LP, AF
Application.ScreenUpdating = True
End Sub |
|