Every function involving excel in memory remains a excel process, even closed software cannot end,

Always perform closed, as follows:
M_varExcelApp. OleFunction (" Quit ");//exit Excel
M_varSheet=Unassigned ();
M_varWorkbook=Unassigned ();
M_varExcelApp=Unassigned ();

Please expert advice, thank you!

CodePudding user response:

Did you ever have the Save operation?

CodePudding user response:

Save or not ah

CodePudding user response:

refer to the second floor scorrre response:

Save or no

Because of have the Save operation, improper disposal of exit would lead to Excel process cannot properly, usually situation is: the target file already exists, perform the Save or SaveAs box will pop up a reminder when asked whether coverage, so, post your code near the Save operation, first