Quantitative Analysis
Parallel Processing
Numerical Analysis
C++ Multithreading
Python for Excel
Python Utilities
Services
Author

I. Motivation and design (PFE).
II. Installation of the Python for Excel.
III. Tutorial introduction into the Python for Excel.
IV. PFE Programmer's reference.
1. Direct access to Excel API.
2. Lower level access to Excel API.
3. Event trapping (PFE).
A. OnNewWorkbook property (ExcelListener).
B. OnSheetActivate property (ExcelListener).
C. OnSheetBeforeDoubleClick property (ExcelListener).
D. OnSheetBeforeRightClick property (ExcelListener).
E. OnSheetCalculate property (ExcelListener).
F. OnSheetChange property (ExcelListener).
G. OnSheetDeactivate property (ExcelListener).
H. OnSheetFollowHyperlink property (ExcelListener).
I. OnSheetSelectionChange property (ExcelListener).
J. OnWindowActivate property (ExcelListener).
K. OnWindowDeactivate property (ExcelListener).
L. OnWindowResize property (ExcelListener).
M. OnWorkbookActivate property (ExcelListener).
N. OnWorkbookBeforeClose property (ExcelListener).
O. OnWorkbookBeforePrint property (ExcelListener).
P. OnWorkbookBeforeSave property (ExcelListener).
Q. OnWorkbookDeactivate property (ExcelListener).
R. OnWorkbookNewSheet property (ExcelListener).
S. OnWorkbookOpen property (ExcelListener).
4. Configuration files (PFE).
Index. Contents.

OnWorkbookBeforeClose property (ExcelListener).


he WorkbookBeforeClose property provides facilities for trapping an Excel event fired before closing a workbook. Consider the following code.


Figure

The output of the signature() method shows that an event handler is expected to take one argument and return a boolean value. If such value is True when returned by the last processed event handler then the workbook closing would be stopped. The code below illustrates the ideas.


Figure

Consequently, any attempt to close any workbook in the current instance of Excel is stopped and every time the new output is directed to ControlShell as shown below.


Figure





Index. Contents.


















Copyright 2007