- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# 3171jj
Sub example2()
Dim f, ar, r, fname
f = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls),*.xls", Title:="¿ï¾Ü¦hÓÀÉ®×", MultiSelect:=True)
If Not IsArray(f) Then Exit Sub
Application.ScreenUpdating = False
'»Ýn¥ý«Ø¤@Ó¥s"·J¾ã"ªº¤u§@ªí
r = 1
For Each fname In f
With Workbooks.Open(fname)
.Sheets(1).Range("3:3,5:5,10:10,11:11").Copy ThisWorkbook.Sheets("·J¾ã").Cells(r, "A")
r = r + 4 '¨C¦¸·s¼W4¦C
.Close False
End With
Next
Application.ScreenUpdating = True
End Sub |
|