|
Tamas Szabo
Posts: 28
Joined: 2008-07-03
|
Dear Developers,
We use 7.6.1219 Premium version of Addin Expr. (Delphi7)
We develop an addinmodule supportedapps (Excel, Outlook, Word) and regarding Excel we are having a problem.
There is a client program from which we call an Excel file.
Trying to handle the opening in different ways we face different problems.
1. If we use ExcelApplication.Workbooks.Open(..) then when closing the last document the finalization part of addinmodule runs, but the Excel.exe gets stuck among the processes running in the background. When opening the next file controls of addin are already not visible. Though it will not be disabled it is invisible.
2. In case of calling by ShellExecute the problem is that it neither runs into the WorkbookOpen event of addinmodule. However it runs into the events of addinmodule.
Kind regards,
Tamas |
|
|
Andrei Smolin
Add-in Express team
Posts: 18829
Joined: 2006-05-11
|
Hello Tamas,
#1. This is supposedly caused by an unreleased COM object. Please see http://www.add-in-express.com/creating-addins-blog/2011/11/04/why-doesnt-excel-quit/.
#2. Different way of starting an Office application may produce different results. This may also depend on the Office version.
In your situation, you cannot assume that the WorkbookOpen event is obligatory: you can start Excel without your add-in and turn it on AFTER a number of workbooks are opened. This means, you also need to handle workbooks in the Workbooks collection; I believe this is how you solve this issue. Aslo note that a workbook opened in a ProtectedViewWindow is not listed in the Workbooks collection. You need to check such a workbook in the ProtectedViewWindows collection: you get a workbook using ProtectedViewWindow.Workbook.
Andrei Smolin
Add-in Express Team Leader |
|
Forums
Topics
Search
Help
Login
Register