本帖最后由 icenotcool 于 2013-9-2 23:33 编辑
各位老师,我想把表一个接一个黏贴,先是表内之间,然后是工作簿之间黏贴,谢谢大家了
Sub 保存()
With ("科室填写表打印版")
UnprotectPassword:="123456" Worksheets("科室填写表打印版").Range("a3:f93").Copy
Worksheets("数据库").Range("a1").PasteSpecial xlPasteValues
Call Copy
Dim wkbk As Workbook, wk As Workbook
Set wk = ThisWorkbook
Set wkbk = Workbooks.Open(ThisWorkbook.Path & "\超时加班费月度汇总.xls")
wkbk.Sheets("数据库").Cells.Copy wk.Sheets("急诊科").[a2]
Workbooks(ThisWorkbook.Path & "\超时加班费月度汇总.xls").Close '关闭
Protect Password:="123456" End With End Sub
附件
问题.rar
(274.9 KB, 下载次数: 7)
|