- ©«¤l
- 561
- ¥DÃD
- 160
- ºëµØ
- 0
- ¿n¤À
- 725
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2014-9-10
- ³Ì«áµn¿ý
- 2024-8-7
|
¸Õ¸Õ
Sub yy()
Dim a As Workbook, f$
Dim p$, sh As Worksheet
Set a = ThisWorkbook
p = "D:\MYCSV\"
f = Dir(p & "*.CSV")
Application.ScreenUpdating = False
Do While f <> ""
Workbooks.Open p & f
For Each sh In Worksheets
'On Error Resume Next
X = WorksheetFunction.CountA(sh.Range("a1:iv65536"))
Y = ActiveWorkbook.Name
If X <> 0 Then
sh.Copy after:=a.Sheets(a.Sheets.Count)
End If
Next
Windows(f).Close True
f = Dir
Loop
Application.ScreenUpdating = True
Sheet1.Select
Range("A1").Select
End Sub |
|