输入代码 '功能:把多个excel工作簿的第一个sheet工作表合并到一个excel工作簿的多个sheet工作表,新工作表的名360新知称等于原工作簿的名称Sub Books2Sheets() '定义对话框变量 Dim fd As FileDialog 没映列毫径建架军女Set fd = Ap宁结历卫径爱plication.FileDialog(m京层货留钱微蛋陆围白soFileDialogFilePicker) '新建一个工作簿 Dim newwb As Workbook Set newwb = Workbooks.Add With fd If .Show = -1 The慢井粒本状足n '定义单个文件变量 Dim vrtSelectedItem As Variant '定义循环变量 Dim i As Integer i = 1 '声尔伟记则开始文件检索 For Each vrtSelectedItem In .SelectedItems '打开被合并工作簿 Dim 目的站席流表顶引形tempwb As Workbook Set tempwb = Work福克烈黄实皮入白部江books.Open(vrtSelectedItem) '复制工作表 tempwb.Worksheets(1).Copy Before:化合=newwb.Worksheets(i) '把新工作簿的工作表名字改成被复制工作簿文件名,这儿应用于xls文件,即Excel97-2003的文件,如果是Excel2007,需要改成xls绍千间商怀景自盾x newwb.Workshee间诗己乐安抓编征回肉策ts(i).Name = V室露或该今建得阿BA.Replace(tempwb.Name, ".xls", "") '关闭被合并工作簿 行让动吗联建茶再轻tempwb.Close 很题SaveChanges:=False i = i + 1 Ne建否大态三损属展紧xt vrtSelectedItem End If End With Set fd = Nothing End Sub
|