protocoll actions with an excel appication object

[josef123]

Hi,

I have a tool which uses an excel application object for doing some
calculation and creating a xls file.
Is there a way to exactly protocoll what is done with the excel
application object?
Two ideas I had was either tracing each object call to the excel object
or by protocolling each action within excel (would e.g. a logging
macros be excuted if excel is used als
application obejct)?

Thanks,
Martin

 

[Harlan Grove]

josef123 wrote...

I have a tool which uses an excel application object for doing some
calculation and creating a xls file.
Is there a way to exactly protocoll what is done with the excel
application object?
Two ideas I had was either tracing each object call to the excel object
or by protocolling each action within excel (would e.g. a logging
macros be excuted if excel is used als
application obejct)?

'Protocoll' isn't an English verb. What do you mean?

Excel application instances run via Automation are always scripted, and
there's no practical way to record what an external script does through
the Excel application instance. That said, you can use the Excel
Application class's UserControl property to determine whether the
current instance was launched interactively or via Automation.

 

[josef123]

hi Harlan Grove,

'Protocoll' isn't an English verb. What do you mean?

sorry, i mean: log all actions of an excel application object.

Excel application instances run via Automation are always scripted, and
there's no practical way to record what an external script does through
the Excel application instance. That said, you can use the Excel
Application class's UserControl property to determine whether the
current instance was launched interactively or via Automation.

yes its run via Automation (not interactively) and btw. I doen't have
any source code of the tool.
is there absolutly no way to get out what the tool done with the excel
application object?

thx,
josef

 

[Harlan Grove]

josef123 wrote...
....

is there absolutly no way to get out what the tool done with the excel
application object?

Not that I'm aware of.