Event 1 Office Connector Web HelpOnline Help

Dump Call Stack Trace Command
Contents Index

  This command is only available via the Technical Support toolbar, which can be activated via the Advanced section of the Preferences window.

When tracing is active, Office Connector maintains statistics on operations that are executed.  This information can be gleaned from the trace log, but the Dump Call Stack Trace command makes it much easier to do.  Dumping the call stack trace to Excel also erases it from memory, effectively resetting the counters.  This makes it convenient to see everything that happens in response to a specific action you take.

The Grid

When you click the <Dump Call Stack Trace> button, a new worksheet is inserted into your workbook and a formatted table is populated with the statistical data.  The rows appear in the order that the operations were executed, except that if an operation occurs multiple times, the additional instances will be represented in the initial row.  The columns are explained below:

Instances

This is a counter that indicates how many times a particular operation has been executed with the associated combination of parameters.

Cell

If the operation was a workbook function, this will indicate the function's cell address.  For operations where cell addresses do not apply, unknown will be listed.

Operation

The name of the command or workbook function.

Stack Depth

Indicates the number of items on the call stack when the operation executed.  When an operation starts the sequence of events, the stack depth will be 1.  If another operation is triggered while the first operation is pending, then the stack depth will be 2.  Normally this number does not exceed 2.

Param 1 … Param 6

These columns list the parameters that were passed to workbook functions.

Remarks

This functionality is only available when tracing is turned on.

See Also



Content updated 3/6/2007
Copyright © 2007 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.