Home > Software engineering >  VB excel cannot end process after operation
VB excel cannot end process after operation

Time:10-12

Tried many times repeatedly, to determine the problem in the following code,

The community=xlsheetoriginal. Application. WorksheetFunction. Max (Range (Cells (2 a), Cells (m, a)))
Community2=xlsheetoriginal. Application. WorksheetFunction. Max (Range (Cells (2, b), Cells (m, b)))
If community2 & gt; The community Then
The community=community2
End the If
The car=xlsheetoriginal. Application. WorksheetFunction. Max (Range (Cells (2, c), Cells (m, c)))

Because I was a half tone, only know that this statement should be something not defined inside the parent object, leading to run after the completion of the excel. Exe can not end, but checked the along while also didn't found out something which is it,

CodePudding user response:

To invoke the excel shutdown command.

CodePudding user response:

Application. The Quit should be able to exit the Excel

CodePudding user response:

Definition:
Private m_objExcel As Excel. Application
Shut down
M_objExcel. Quit

CodePudding user response:

After the operation, to give off the EXCEL
  • Related