|
楼主 |
发表于 2017-9-22 22:02
|
显示全部楼层
借用黄老师思路,用三个数组,把三类文件分列在三个列上。
Sub 用dr在A列音频B列视频列目录()
Dim arr(), brr(), crr()
s1 = ".mp3.WMA.WAV.wma.wav.mid.OGG.APE.ACC." '音频文件
s2 = ".3gp.ts.swf.tp.ifo.nsv.tta.as3."
s3 = ".mp4.mp5.wkv.avi.wmv.flv.f4v.rm.rmvb.rmv.dat.asf.mov.vob."
flnm = Dir(ThisWorkbook.Path & "\音视频\*.*")
Do While flnm <> ""
If InStr(s1, Split(flnm, ".")(UBound(Split(flnm, ".")))) > 0 Then
n = n + 1
ReDim Preserve arr(1 To n)
arr(n) = flnm
ElseIf InStr(s2, Split(flnm, ".")(UBound(Split(flnm, ".")))) > 0 Then
m = m + 1
ReDim Preserve brr(1 To m)
brr(m) = flnm
ElseIf InStr(s3, Split(flnm, ".")(UBound(Split(flnm, ".")))) > 0 Then
p = p + 1
ReDim Preserve crr(1 To p)
crr(p) = flnm
End If
flnm = Dir
Loop
Sheets("sheet2").Range("A1").Resize(UBound(arr), 1) = Excel.Application.Transpose(arr) '音频文件
Sheets("sheet2").Range("B1").Resize(UBound(brr), 1) = Excel.Application.Transpose(brr) '视频文件
Sheets("sheet2").Range("c1").Resize(UBound(crr), 1) = Excel.Application.Transpose(crr)
End Sub |
|