需要在VBE界面上引用EXCEL库才能打开Excel文件。最简单的语句如下所示:
Sub test()
Dim xcl As New Excel.Application
Dim wbk As Workbook
Set wbk = xcl.Workbooks.Open(“E:\1.xls”)
xcl.Visible = True
End Sub
时间:2022-03-10 19:35:36
需要在VBE界面上引用EXCEL库才能打开Excel文件。最简单的语句如下所示:
Sub test()
Dim xcl As New Excel.Application
Dim wbk As Workbook
Set wbk = xcl.Workbooks.Open(“E:\1.xls”)
xcl.Visible = True
End Sub