E
ExcelMonkey
I want to create a soluton which tracks events in Excel. Typically you could
do this in VBA using the Worksheet_Change event. However, as the VBA can be
disabled, a solution of this nature is not optimal.
I enquired as to whether I could write a Microsoft Service to track these
events. I was informed that:
"Microsoft does not currently recommend, and does not support, Automation of
Microsoft Office applications from any unattended, non-interactive client
application or component (including ASP, ASP.NET, DCOM, and NT Services),
because Office may exhibit unstable behavior and/or deadlock when Office is
run in this environment."
Is it possible to create a solution of this nature using VSTO? Or would
this still be vulnerable to any type of disablement of the solution? I am
assuming it would have to be in the form of an Add-in. Again, it's sole
purpose it to track events that occur in Excel while the user is working on
any given spreadsheet.
Thanks
EM
do this in VBA using the Worksheet_Change event. However, as the VBA can be
disabled, a solution of this nature is not optimal.
I enquired as to whether I could write a Microsoft Service to track these
events. I was informed that:
"Microsoft does not currently recommend, and does not support, Automation of
Microsoft Office applications from any unattended, non-interactive client
application or component (including ASP, ASP.NET, DCOM, and NT Services),
because Office may exhibit unstable behavior and/or deadlock when Office is
run in this environment."
Is it possible to create a solution of this nature using VSTO? Or would
this still be vulnerable to any type of disablement of the solution? I am
assuming it would have to be in the form of an Add-in. Again, it's sole
purpose it to track events that occur in Excel while the user is working on
any given spreadsheet.
Thanks
EM