I'm writing a small tool in c# that need to read data from a given Excel table. Each column header is assigned with a name as a Named Range. And I need to read thru these names to know which information are stored in each columns.
For example in $AR$132, I have a range namely...
I am trying to handle events of Com object (PCOMM) in .Net. My problem is that when attaching a handler to the event I get the error below.
"Event invocation for COM objects requires event to be attributed with DispIdAttribute"
Private WithEvents p as New...