Dim lujin$ Dim ming$ lujin = ActiveWorkbook.Path ming = Workbooks.Add.Name Application.Workbooks("book1").Worksheets("sheet1").Copy_ Application.Workbooks(ming).Worksheets ("sheet1")
Dim ming$ Workbooks("book1.xls").Worksheets("sheet1").Copy '复制book1的sheet1到新工作簿 ming = ActiveWorkbook.Name '获取新工作簿的名称 Workbooks("book1.xls").Activate '重新激活book1
Dim ming$ Workbooks("book1.xls").Worksheets("sheet1").Copy '复制book1的sheet1到新工作簿 ming = ActiveWorkbook.Name '获取新工作簿的名称 Workbooks("book1.xls").Activate '重新激活book1