需要在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
时间:2023-10-12 16:41:43
需要在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