protocoll actions with an excel appication object

J

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
 
H

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)?
Click to expand...

'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.
 
J

josef123

hi Harlan Grove,
'Protocoll' isn't an English verb. What do you mean?
Click to expand...

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.
Click to expand...

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
 
Top