如何在当前打开的Excel文件中打开另外一个excel文件,并取得workbook对象?
c104 2006-01-26 11:47:07 如,我在打开的xls1中打开xls2,下面是xls1中某一个按钮的代码
我如何获取新打开的xls2文件的workbook对象?
我不希望激活新打开的xls2文件的workbook和sheet,目的是取xls2文件中的一些数据填充到xls1中去
Sub openFile()
Dim Excel As Variant
Dim ExcelApp As Variant
Dim ExcelSheets As Variant
Dim ActiveSheet As Variant
Dim Workbook As Variant
Set ExcelApp = CreateObject("Excel.Application")
Call Excel.Application.Workbooks.Open(xls2FileName) 'xls2FileName是需要打开的excel文件路径
Set Workbook = ExcelApp.Workbook(2) '这句就报错,无法获取Workbook对象
...
End Sub