工作薄 [book1] 中有三个表,sheet1 ,sheet2,sheet3,如何将它们拆分成三个独立同名的工作薄? 比如说变成四个工作薄,存在同一路径下 [Book1],[sheet1],[sheet2],[sheet3]
也可以用VBA Sub 导出为Excel文件() Application.ScreenUpdating = False MM = ThisWorkbook.Path CC = Sheets.Count For X = 1 To Sheets.Count NN = Sheets(X).Name Sheets(X).Copy ActiveWorkbook.SaveAs MM & "\" & NN & ".XLS" ActiveWorkbook.Close True Next X Application.ScreenUpdating = True End Sub
[此贴子已经被作者于2010-6-14 19:41:25编辑过]
|