T
Tony F
Hi there. I have recently been getting into using office
automation with .net clients, specifically Vb.net and
Excel (2002). There are two things I'm trying to find
out if they are possible or not:
1) There are plenty of examples of calling excel (or any
office app) macros from a .net client. How about the
other way? Is there a way to get a excel macro (or other
code type) to call a method from an .net automation
client?
2) Again, there are plenty of examples of catching excel
events from a .net automation client. There are the
build in events such as Worksheet.Active, etc...
However, I'm trying to catch an event from an activex
control on a spreadsheet, such as the click of an activex
button added to the spreadsheet. Is it possible to
directly (or indirectly) catch these events from a .net
autoamtion client? I'd settle for a vba macro in excel
handlding the event, if it could then call a method in
the .net auto client (see item #1 above). This could
indirectly do the trick.
Also, if the only way to catch the event were to
programmatically add the activex control to the excel
spreadsheet, great, how do you do that?
Thanks for anyone's time in responding to this.
Tony Fox
automation with .net clients, specifically Vb.net and
Excel (2002). There are two things I'm trying to find
out if they are possible or not:
1) There are plenty of examples of calling excel (or any
office app) macros from a .net client. How about the
other way? Is there a way to get a excel macro (or other
code type) to call a method from an .net automation
client?
2) Again, there are plenty of examples of catching excel
events from a .net automation client. There are the
build in events such as Worksheet.Active, etc...
However, I'm trying to catch an event from an activex
control on a spreadsheet, such as the click of an activex
button added to the spreadsheet. Is it possible to
directly (or indirectly) catch these events from a .net
autoamtion client? I'd settle for a vba macro in excel
handlding the event, if it could then call a method in
the .net auto client (see item #1 above). This could
indirectly do the trick.
Also, if the only way to catch the event were to
programmatically add the activex control to the excel
spreadsheet, great, how do you do that?
Thanks for anyone's time in responding to this.
Tony Fox