|
本帖最后由 love_liwu 于 2015-7-24 21:36 编辑
老师,您好,现追加一个问题:
假设现在工作簿有7个工作表,除了sheet1和顾客信息表外,还有其他5个工作表(DATA、代码表:深度隐藏),现在我想批量生成除sheet1外其他工作表都有的工作簿(DATA、代码表继续深度隐藏),现在已经知道sheet1是没有设置保护密码,其余的工作表均已设置保护密码,请问以下代码(感谢grf1973老师提供的代码)如何作进一步修改?
PS:如果该工作簿均设保护密码,代码是否一样呢?
Sub tt()
Dim wb As Workbook
Set wb = Workbooks.Open(ThisWorkbook.Path & "\顾客信息.xls")
Application.DisplayAlerts = False
Application.ScreenUpdating = False
arr = wb.Sheets(1).[a1].CurrentRegion
For i = 2 To UBound(arr)
If i = 2 Then wb.Worksheets(1).Delete
wb.SaveAs ThisWorkbook.Path & "\" & arr(i, 1) & ".xls"
With ActiveWorkbook.Sheets(1)
.[c4] = arr(i, 1)
.[g4] = arr(i, 2)
.[c5] = arr(i, 3)
.[g5] = arr(i, 4)
.[c6] = arr(i, 5)
.[g6] = arr(i, 6)
.[c13].Resize(1, 4) = Array(arr(i, 7), arr(i, 8), arr(i, 9), arr(i, 10))
End With
ActiveWorkbook.Save
Set wb = ActiveWorkbook
Next
wb.Close
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub
demo.zip
(30.56 KB, 下载次数: 7)
|
|