CodePudding user response:

Dim xlApp As Excel. Application
Dim xlBook As Excel. The Workbook
Dim xlSheet As Excel. The Worksheet




The Set xlApp=CreateObject (" Excel. Application ")
The Set xlBook=xlApp. Workbooks. Open (" E: \ VB \ MXS XLS ")
XlApp. Visible=True
Is to open the EXCEL

CodePudding user response:

One is directly open the EXCEL, one is to use VB to open the EXCEL

CodePudding user response:

Didn't understand what you mean,,,

Directly open the Excel and use VB to open the Excel will what's the difference?

You said (load) is in Excel options come oh

CodePudding user response:

See if the add-in:

CodePudding user response:

The Set ex1=CreateObject (" excel. Application ")
The Set exwbook=ex1. Workbooks (). The Open (" E: \ VB \ MXS. XLS ")
Ex1. Visible=True

Didn't you say problems ~ see screenshot you are using office2003 ~ I am office2010 ~ don't know whether I version problem

CodePudding user response:

refer to the second floor hlupin response:

One is directly open the EXCEL, one is to use VB to open the EXCEL

Can share the add-in DLL and open XLS? I can't repeat here.

CodePudding user response:

Remove the excel library reference to try

CodePudding user response:

This is another solution
https://blog.csdn.net/l490134872/article/details/80250395