ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸ê®Æ·JÁ`

¦^´_ 1# ÅÚ½³ªd

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Sub ¶×Á`()
Dim Arr, x&, R%
Application.ScreenUpdating = False   'Ãö³¬¿Ã¹õ§ó·s
Application.DisplayAlerts = False
Sheets("Á`ªí").UsedRange.Offset(1, 0).Clear  '²M°£ªíÀY¤§¥~ªº©Ò¦³¤º®e
With Application.FileDialog(msoFileDialogOpen)
    .InitialFileName = "D:\"
    .AllowMultiSelect = True
    .Title = "======= ¿ï¾Ü¨Ó·½ªºÀÉ®× ========"
    .Show
    If .SelectedItems.Count = 0 Then Exit Sub
    Tm = Timer
    For x = 1 To .SelectedItems.Count
        FPath = .SelectedItems(x)
        With Workbooks.Open(FPath)
            With Sheets(2)
                Arr = .Range("a6:h" & .[A65536].End(3).Row)
            End With
            .Close
        End With
        R = Sheets("Á`ªí").[d65536].End(xlUp).Row + 1
        Sheets("Á`ªí").Range("d" & R).Resize(UBound(Arr), UBound(Arr, 2)) = Arr
    Next
End With
MsgBox Timer - Tm & "’"
Application.ScreenUpdating = True   '«ì´_¿Ã¹õ§ó·s
Application.DisplayAlerts = True
End Sub

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD