excel 宏 如何在新生成的文件引用源文件的数值
答案:3 悬赏:50
解决时间 2021-01-27 15:32
- 提问者网友:箛茗
- 2021-01-27 09:41
excel 宏 如何在新生成的文件引用源文件的数值
最佳答案
- 二级知识专家网友:怙棘
- 2021-01-27 10:05
Sub test()
Dim n, t
Dim oldBook, newBook As Workbook
Set oldBook = ActiveWorkbook
n = Sheets("sheet1").Cells(3, 2)
t = Sheets("sheet1").Cells(3, 4)
Sheets(Array("sheet2", "sheet3")).Copy
Set newBook = ActiveWorkbook
ChDir "C:\Users\Administrator\Desktop\test\"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Administrator\Desktop\test\" & t & n & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
End Sub
现在,你可以使用oldBook这个对象来引用源工作簿、newBook来引用新工作簿:
newBook.sheets("sheet2").range("A1")=oldBook.sheets("sheet1").range("A1")
Dim n, t
Dim oldBook, newBook As Workbook
Set oldBook = ActiveWorkbook
n = Sheets("sheet1").Cells(3, 2)
t = Sheets("sheet1").Cells(3, 4)
Sheets(Array("sheet2", "sheet3")).Copy
Set newBook = ActiveWorkbook
ChDir "C:\Users\Administrator\Desktop\test\"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Administrator\Desktop\test\" & t & n & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
End Sub
现在,你可以使用oldBook这个对象来引用源工作簿、newBook来引用新工作簿:
newBook.sheets("sheet2").range("A1")=oldBook.sheets("sheet1").range("A1")
全部回答
- 1楼网友:枭雄戏美人
- 2021-01-27 11:50
你的引用是指不要链接的吗?只复制数字那种?如果是的话,可以使用workbooks.open 语句,然后range.copy ,可以试试
- 2楼网友:胯下狙击手
- 2021-01-27 11:38
Sub test()
Dim n, t
n = Sheets("sheet1").Cells(3, 2)
t = Sheets("sheet1").Cells(3, 4)
Sheets(Array("sheet2", "sheet3", )).Copy
ChDir "C:UsersAdministratorDesktop est"
activesheet.[a1]=sheets(1).[a1]
ActiveWorkbook.SaveAs Filename:= _
"C:UsersAdministratorDesktop est" & t & n & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
End Sub
Dim n, t
n = Sheets("sheet1").Cells(3, 2)
t = Sheets("sheet1").Cells(3, 4)
Sheets(Array("sheet2", "sheet3", )).Copy
ChDir "C:UsersAdministratorDesktop est"
activesheet.[a1]=sheets(1).[a1]
ActiveWorkbook.SaveAs Filename:= _
"C:UsersAdministratorDesktop est" & t & n & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
End Sub
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯