工作簿批量合并代码求修改

pyxzx

在网上找到一个合并文件夹下所有工作簿的代码
1.求高手加个注释，太高深看不懂
2.这个代码有一个错误，它会多复制一个表格，最上面和最下面的一样（未验证中间是否错误）该怎么修改会正确？
3.如果文件夹下有多个扩展名的文件，该如何修改？（比如有xls的，有xlsx的，有xlsm的）
求高手帮忙解答一下，谢谢

1. Dim x As Integer '定义个一公有变量记录复制行数
   
2. '复制多个Excel文件中的内容到一个里
   
3. Sub combine()
   
4.     x = 1
   
5.     Dim folder As String
   
6.     Dim count As Integer
   
7.     folder = ChooseFolder()
   
8.     'count = combineFiles(folder, 'xls')
   
9.     count = count + combineFiles(folder, "xlsm")
   
10.     MsgBox (" succeed ")
    
11. End Sub
    
12. Function combineFiles(folder, appendix)
    
13.     Dim MyFile As String
    
14.     Dim s As String
    
15.     Dim count, n, copiedlines As Integer
    
16.     MyFile = Dir(folder & "\*." & appendix)
    
17.     count = count + 1
    
18.     n = 2
    
19.     Do While MyFile <> ""
    
20.         copiedlines = CopyFile(folder & "" & MyFile, 2, n)
    
21.         If copiedlines > 0 Then
    
22.             n = n + copiedlines
    
23.             count = count + 1
    
24.         End If
    
25.         MyFile = Dir
    
26.         Loop
    
27.         combineFiles = count
    
28.         End Function
    
29. '复制数据
    
30. Function CopyFile(filename, srcStartLine, dstStartLine)
    
31.     Dim book As Workbook
    
32.     Dim sheet As Worksheet
    
33.     Dim rc As Integer
    
34.     CopyFile = 0
    
35.     If filename = (ThisWorkbook.Path & "" & ThisWorkbook.Name) Then
    
36.         Exit Function
    
37.     End If
    
38.     Set book = Workbooks.Open(filename)
    
39.     ThisWorkbook.Activate
    
40.     For j = 1 To book.Sheets.count
    
41.         book.Sheets(j).UsedRange.Copy Cells(x, 1)
    
42.         With ActiveSheet.Cells.Find("*", Cells(1, 1), -4163, 1, 1, 2).MergeArea '通用判断最后一行
    
43.             Rows(.Row + .Rows.count - 1).Select
    
44.             x = Selection.Row + Selection.Rows.count - 1
    
45.         End With
    
46.         x = x + 1
    
47.         Next j
    
48.         book.Close
    
49.         End Function
    
50. '选择文件夹
    
51. Function ChooseFolder() As String
    
52.     Dim dlgOpen As FileDialog
    
53.     Set dlgOpen = Application.FileDialog(msoFileDialogFolderPicker)
    
54.     With dlgOpen
    
55.         If .Show = -1 Then
    
56.             ChooseFolder = .SelectedItems(1)
    
57.         End If
    
58.     End With
    
59.     Set dlgOpen = Nothing
    
60. End Function

复制代码