¦hµ§EXECL ¤§¸ê®Æ,¦X¦b¤@°_
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 5# tomking
»Ý¨D.xls,OS124.xls,OS123.xls µ¥³£¶}±Òªºª¬ºA¤Uªºµ{¦¡½X- Option Explicit
- Sub Ex()
- Dim MyBook As Workbook, B As Workbook, R As Range, i As Long
- Set MyBook = Workbooks("»Ý¨D.XLS")
- For Each B In Workbooks '
- If B.Name <> MyBook.Name Then
- With B.Sheets(1)
- For i = 4 To .Cells(Rows.Count, "A").End(xlUp).Row
- Set R = MyBook.Sheets("LIST").Cells(Rows.Count, "A").End(xlUp).Offset(1)
- R.Resize(, 4) = Array(.[C1], .[E1], .[I2], .[A2])
- R.Offset(, 4).Resize(, 11) = .Range(.Cells(i, "A"), .Cells(i, "K")).Value
- Next
- End With
- End If
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-5-29 10:12 ½s¿è
¦^´_ 7# tomking
"§Y¥i¨úDATA ¬O§_¦³¾÷·|,¥ý±N¨Ó·½DATA ¥ýÂন.csv, ¦A¨údata. " ¬Ý¤£À´°Ú
Àɮפ@©wn¶}±Ò ¸Õ¸Õ¬Ý- Option Explicit
- Sub Ex()
- Dim R As Range, i As Long, ii As Integer
- With Application.FileDialog(msoFileDialogOpen) 'ÀÉ®×¹ï¸Ü¤è¶ô°õ¦æÓÅé
- .AllowMultiSelect = True '¥i½Æ¿ïÀÉ®×
- .InitialFileName = "D:\TEST" '¥iקאּ§An¶}±Òªº¥Ø¿ý
- .Show 'Åã¥ÜÀÉ®×¹ï¸Ü¤è¶ô
- If .SelectedItems.Count >= 1 Then '¿ï¾ÜªºÀÉ®×¼Æ
- For i = 1 To .SelectedItems.Count '¨Ì§Ç¦b¿ï¾ÜªºÀÉ®×
- With Workbooks.Open(.SelectedItems(i)) '¶}±ÒÀÉ®×
- With .Sheets(1)
- For ii = 4 To .Cells(Rows.Count, "A").End(xlUp).Row
- Set R = Workbooks("»Ý¨D.XLS").Sheets("LIST").Cells(Rows.Count, "A").End(xlUp).Offset(1)
- R.Resize(, 4) = Array(.[C1], .[E1], .[I2], .[A2])
- R.Offset(, 4).Resize(, 11) = .Range(.Cells(ii, "A"), .Cells(ii, "K")).Value
- Next
- End With
- .Close False 'Ãö³¬Àɮפ£¦sÀÉ
- End With
- Next
- End If
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|