我定义了一个 Dim xlbook As Workbook,我想把 一个excel文件负给它，是哪个属性来着

[shennongjia]

Dim xlbook As Workbook


xlbook.???? = App.Path & "\orders1.xls"

[shennongjia]

helpme

[shennongjia]

人呢

[footballboy]

Dim xlApp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet

Private Sub Command1_Click()
Set xlApp = New Excel.Application
Set xlbook = xlApp.Workbooks.Open("c:\temp\模板.xls")
Set xlsheet = xlbook.Worksheets(1)

xlsheet.Range("A1") = "ABC"
xlbook.Save
xlbook.Close
xlApp.Quit
Set xlApp = Nothing
End Sub