c# - How to handle events from embedded Excel.OleObjects or Excel.Shapes -


i'm working on c# , vb.net ports of old vba program. has lots of msforms/oleobjects embedded in commandbutton or images.

my first thought declare buttons microsoft.vbe.interop.forms.commandbuttonbut leads com exception system._com type can't cast ...forms.commandbutton. if try more generic version of this solution, don't find items, , if try go through vbcomponets note sheets in workbook, none of controls:

foreach (vbcomponent xxx in globals.thisworkbook.vbproject.vbcomponents) {     interaction.msgbox(xxx.name);     interaction.msgbox(xxx.tostring); }

thus of these controls not in .vbcomponets, can find them oleobjects in thisworkbook.worksheets(n).oleobjects (this counterintutive me, don't understand system begin with).

how handle click action such object?

i'm assuming need using excel.oleobjectevents_event interface, can't seem figure out how. if try make custom events delegates, don't seem able assign them oleobjects. if use actionclickeventhandler.createdelegate can huge variety of errors makes me think that's dead end.

the official documentation ms doesn't seem helpful, though did introduce me idea of verb, i'm looking into. far has produced com errors along lines of "application failed start."

even trying use 1 of 2 standard events, .gotfocus, pull 0x80040200 error. example:

excel.oleobject buttoncatcher = globals.thisworkbook.worksheets(1).oleobjects("commandbutton1"); buttoncatcher.gotfocus += commandbutton1_click;

throws comexception exception hresult: 0x80040200 @ second line. button enabled, checked after looking code number office dev site.

trying more generic approach within code sheet containing controls:

object commandbuttonstart = this.gettype().invokemember("commandbutton1", system.reflection.bindingflags.getproperty, null, this, null);

throws missing method error.

any appreciated, seems should obvious , i'm missing it.

**edit: have found can cast these controls excel.shape doesn't me closer running function or sub vsto. i'm playing excel.shape.onaction requires vba sub called. presumably call vba sub calls sub vsto long vsto com visible. seems round-about , i'd last resort.

have tried using newlatebinding.lateget?

using msforms = microsoft.vbe.interop.forms; using microsoft.visualbasic.compilerservices;  ...  msforms.commandbutton commandbutton1 = (msforms.commandbutton)newlatebinding.lateget(globals.thisworkbook.worksheets(1), null, "commandbutton1", new object[0], null, null, null);                 commandbutton1.click += new microsoft.vbe.interop.forms.commandbuttonevents_clickeventhandler(commandbutton1_click);

it's referenced on msdn in vsto forums , in old blog post.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more