VB打开EXCEL文件,让EXCEL文件显示在最前面，且最大化。这样的VB代码如何编写。

Question

如题所述

Answer 1

sub openwksht

Dim xlapp As Excel.Application
Dim xlbook As Excel.Workbook

Set xlapp = CreateObject("excel.application")
Set xlbook = xlapp.Workbooks.Open("你要打开的文件路径和文件名 ")
xlapp.Visible = True
xlapp.WindowState = xlMaximized
xlbook.activate
End Sub