用vb如何在excel文件之间复制sheet? 例如有 file1.xls和file2.xls两个excel文件,file1.xls里面有个sheet1,file2.xls里面有个sheet2,要想把sheet1作为一个增加的sheet复制到file2.xls里面去,要怎么做呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Set chApp = CreateObject("Excel.Application")chApp.Visible = visibleSet source = chApp.Workbooks.Open(cPath & "file1.xls", 0)Set template = chApp.Workbooks.Open(cPath & "file2.xls", 0)source.Activatesource.Sheets("sheet1").SelectchApp.Cells.SelectchApp.Selection.Copytemplate.Activatetemplate.Sheets("sheet2").SelectchApp.Cells.SelectchApp.ActiveSheet.PastechApp.Range("A1").Select Dim newApp As New Excel.Application Dim newBook1 As New Excel.Workbook Dim newBook2 As New Excel.Workbook Set newBook1 = newApp.Workbooks.Open("D:\file1.xls") '---输入你的正确路径 Set newBook2 = newApp.Workbooks.Open("D:\file2.xls") '---输入你的正确路径 '下面表示把file1.els里的sheet1复制到file2.xls里的sheet2后面 newBook1.Worksheets("sheet1").Copy after:=newBook2.Worksheets("sheet2") newApp.Visible = True Set newBook1 = Nothing Set newBook2 = Nothing Set newApp = Nothing 睡知道那有好用的生成统计学图形的控件阿,最好是医学方面的 VB写的DLL无法在网页调用,请问何解?急,谢谢!!! 还是关于文本框滚动的问题,请高手兄弟帮忙啊!! 如何将选中的内容复制到一个临时的word中 急!!!adodb连接access加密数据库失败... 如何在form_unload事件中中止窗体的卸载? 关于ADO的记录集查询 在VB中添加.gif图片 我想酷一点 VB 程序提示activex component can't create object 如何在VB中调用VBS里的Execute语句 用winsock实现ftp,ftp服务器吧150和226放在一起发送。。。
chApp.Visible = visible
Set source = chApp.Workbooks.Open(cPath & "file1.xls", 0)
Set template = chApp.Workbooks.Open(cPath & "file2.xls", 0)source.Activate
source.Sheets("sheet1").Select
chApp.Cells.Select
chApp.Selection.Copytemplate.Activate
template.Sheets("sheet2").Select
chApp.Cells.Select
chApp.ActiveSheet.Paste
chApp.Range("A1").Select
Dim newBook1 As New Excel.Workbook
Dim newBook2 As New Excel.Workbook
Set newBook1 = newApp.Workbooks.Open("D:\file1.xls") '---输入你的正确路径
Set newBook2 = newApp.Workbooks.Open("D:\file2.xls") '---输入你的正确路径
'下面表示把file1.els里的sheet1复制到file2.xls里的sheet2后面
newBook1.Worksheets("sheet1").Copy after:=newBook2.Worksheets("sheet2")
newApp.Visible = True
Set newBook1 = Nothing
Set newBook2 = Nothing
Set newApp = Nothing